Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “dismes” with Change Limit: [1] [2] [3]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

87 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
dismes9561767(None) 
dimes85833041di_mes
dishes104622651dishes
disme85716241disme_
disses75225961disses
aisles64721142aisles
biomes103815252biomes
bises75435622bis_es
daises74318982dais_es
daisies84217092daisies
dames85435852d_ames
dashes106124982dashes
deisms94411042deism_s
demes86032692d_emes
dices86434242di_ces
didies84621832didies
didoes85716962didoes
dienes75719902dienes
dies55653522di__es
dieses75218692dieses
dikes105831332di_kes
dime76237642di_me_
dimer85625602di_mer
dimers94321092di_mers
dimmed124110322dimmed
dimmer114112612dimmer
dimmers123811562dimmers
dimmest1249252dimmest
dims75435022di_m_s
dines66449152di_nes
dinges83825422dinges
diodes83915782diodes
dirges84915102dirges
disced104914652disced
discos94915212discos
discs85316262dis_cs
discus94512112discus
dished114318712dished
disked125015762disked
disks105417472dis_ks
dismal92412242dismal
dismals102010242dismals
dismast10311232dismast
dismay12229472dismay
dismays13237432dismays
dismiss1038152dismiss
dispel9310322dispel
dispels10310502dispels
diss56434482dis__s
dissed85220182dissed
distomes11314162distomes
disuse74012842disuse
disuses84015412disuses
dites66339152di_tes
ditzes163212422ditzes
dives95832402di_ves
domes85735562d_omes
doses65938502dos_es
dosses76126272dosses
fishes125221342fishes
gimmes113010902gimmes
gismos957182gismos
hisses94719352hisses
isles54220562_isles
isms66213472_ism_s
jisms14458002jism_s
kismet123414622kismet
kismets13306882kismets
kisses104217332kisses
limes75636502li_mes
lisles63416282lisles
mimes95732022mi_mes
mises74740562mis_es
mismet103722372mismet
misses85130872misses
pishes114722102pishes
pisses84525082pisses
pistes85325632pistes
rimes75634542ri_mes
rises55244042ris_es
sises55233832sis_es
sisses64520602sisses
times75630822ti_mes
vises84427772vis_es
wises85633192wis_es
wishes124920952wishes
wisses94619602wisses

Search took 6 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter178691825510.233766914.2
2DLD Change Limit82551875.45615130.3
3Display Results87870.0461891.3
 (SQL Overall)178691875.73531158.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.