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 “tzimmes” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

150 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
tzimmes203306(None) 
tsimmes1133671tsimmes
gimmes113010902_gimmes
times75630822t_i_mes
trimmed12348932trimmed
trimmer113610832trimmer
trimmers12288912trimmers
trimmest12227022trimmest
animes84719593ani_mes
azides165113803azi_des
azines155517073azi_nes
biomes103815253_biomes
brimmed14386783brimmed
brimmer13348803brimmer
brimmers14287073brimmers
chimes134922573chi_mes
climes104720003cli_mes
crimes105521583cri_mes
crimmer133310773crimmer
crimmers14298543crimmers
dimes85833043_di_mes
dimmed124110323_dimmed
dimmer114112613_dimmer
dimmers123811563_dimmers
dimmest1249253_dimmest
dismes95617673_dismes
femmes135410213_femmes
gimme102411343_gimme_
gimmies123010113_gimmies
glimes94717523gli_mes
glimmer12437713glimmer
glimmers13396153glimmers
grammes123611323grammes
grimes94619033gri_mes
grimmer123510093grimmer
grimmest13286293grimmest
guimpes1245073guimpes
immesh1334113__immesh
immies102412443__immies
jimmies18328783_jimmies
krimmer15376873krimmer
krimmers16315673krimmers
limes75636503_li_mes
limmer104314793_limmer
limmers113413083_limmers
mimes95732023_mi_mes
nimmed11368573_nimmed
oximes15107423oxi_mes
primes104225263pri_mes
primmed14388853primmed
primmer134310163primmer
primmest14226693primmest
rimes75634543_ri_mes
rimmed114812303_rimmed
rimmer103516033_rimmer
rimmers113812883_rimmers
shammes144312833shammes
shimmed15338583shimmed
shimmer143310873shimmer
shimmers15269413shimmers
shimmies15287803shimmies
simmer104115353_simmer
simmers113314613_simmers
skimmed16306053skimmed
skimmer15327533skimmer
skimmers16296463skimmers
slimes84722043sli_mes
slimmed12368473slimmed
slimmer114211343slimmer
slimmers12369633slimmers
slimmest1235903slimmest
stimes85920573sti_mes
stimies9316563stimies
swimmer14297653swimmer
swimmers15276693swimmers
tagmemes1342833tagmemes
tailles72516473tailles
tames75242013t__ames
tamises92715973tamises
tammies113814683tammies
taxemes1635853taxemes
telomes9310533telomes
themes115319253t_hemes
thermes126214613thermes
thieves1346903thieves
thimbles1536023thimbles
thymes144810743t_hymes
tides64830153t_i_des
tidies74721833t_idies
ties45248313t_i__es
tikes95628903t_i_kes
tildes74513963t_ildes
tiles55542103t_i_les
timber104012683t_imber
timbers113111853t_imbers
timbres11249353t_imbres
time66235013t_i_me_
timed85223613t_i_med
timer75626043t_i_mer
timers84420993t_imers
tines54848423t_i_nes
tinges74722333t_inges
tinmen82310403t_inmen
tires55437493t_i_res
tithes94720213t_ithes
titles63719923t_itles
titmen8239883t_itmen
titres64718933t_itres
tizzies15287893tizzies
toiles63923513toi_les
tomes76037383t__omes
tommed113310143t_ommed
tommies113812983tommies
tonemes9311683tonemes
trammed123810713trammed
trammel11357663trammel
trammels12295413trammels
triages82613793triages
tribes85119023tri_bes
trices84826333tri_ces
trienes74118413trienes
tries55742813tri__es
trifles103814823trifles
trikes105419493tri_kes
trimer85717153tri_mer
trimers94615143trimers
trimness1067563trimness
trims75021473tri_m_s
trines64132563tri_nes
triodes84012503triodes
trioses75015653trioses
tripes85324873tri_pes
triples94616873triples
triremes1035523triremes
trisemes1036643trisemes
trismus935563trismus
trisomes1039833trisomes
triunes74311383triunes
trommel11315363trommel
trommels12254333trommels
trompes114111623trompes
tuilles72411923tuilles
tummies113012033tummies
twines94717273twi_nes
twinges11409453twinges
tzetzes1532673tzetzes
tziganes1853023tziganes
tzitzis1542423tzitzis
zines145232653_zi_nes
zymes1924712943_z_ymes

Search took 8 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 Filter1786911340270.406440125.6
2DLD Change Limit1340271506.73319906.0
3Display Results1501500.0463260.9
 (SQL Overall)1786911507.18524870.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.