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 “kreuzer” 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.

130 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
kreuzer203235(None) 
kreutzer2141271kreutzer
kreuzers2132061kreuzers
freezer19348522freezer
kreutzers2241262kreutzers
arguer74510543argu_er
arouser74514423arouser
beezer174010523_beezer
brazer174917533br_azer
breaker133912923breaker
breeder103210043breeder
breeze17298963breeze_
breezed19287053breezed
breezes18318693breezes
breezier1934533breezier
brevier1237763brevier
brewer114812553bre_wer
bronzer18348493bronzer
creamer113714093creamer
creaser94415743creaser
creeper11339983creeper
crepier1139753crepier
crozer175112843cr_ozer
cruder95612383cr_uder
crueler939023crueler
dreamer104110843dreamer
dredger10347453dredger
dresser83611953dresser
erecter93113393erecter
freer86021243fre__er
freeze18349513freeze_
freezers20307173freezers
freezes193310353freezes
fresher132612643fresher
fretter103412753fretter
frizer184011283fr_izer
frizzer18446893frizzer
frouzier2043703frouzier
geezer16278013_geezer
grazer164815763gr_azer
greaser83913083greaser
greater84416493greater
greener83111713greener
greeter82812673greeter
greyer104510093gre_yer
grouper104210093grouper
grouser84513693grouser
grouter84412523grouter
grueler837023grueler
keener104012843k_eener
keeper123811923k_eeper
keester11319913keester
kegger12388083k_egger
kegler11398243k_egler
kelter103214383k_elter
kiester11329973kiester
klezmer2231933klezmer
kneader1275893kneader
kneeler11277573kneeler
krater104014313kr_ater
kreep114610413kre__ep
krewe1238193kre_we_
krewes1337923kre_wes
krimmer15376873krimmer
kroner104612573kr_oner
kruller1145153kruller
neuter63713793_neuter
peruser93511373peruser
preaver121011613preaver
preener93114833preener
prefer113813203pre_fer
preluder1135733preluder
premier113515633premier
presser93717623presser
prester93519623prester
presumer1247583presumer
pretzel1835143pretzel
preyer114413733pre_yer
prezes173614693pre_zes
prizer174714883pr_izer
prouder10310383prouder
pruner83413453pr_uner
queuer15357253queu_er
razer144824273_r_azer
reader73628293_reader
realer63528593_realer
reamer84325213_reamer
reaper84223143_reaper
rearer64928913_rearer
reaver94524733_reaver
rebuker13407843_rebuker
redder83918143_redder
reducer1059003_reducer
reefer93314363_reefer
reeker103715593_reeker
reeler63822573_reeler
refer84822143_re_fer
refuser104912783_refuser
refuter104312193_refuter
reiver95318293_reiver
relier65826183_relier
render74024143_render
renter64527413_renter
rester63832433_rester
resumer9410113_resumer
reuse56025363_reuse_
reused75419563_reused
reuses66025523_reuses
reutter71010093_reutter
rezero1578873_re_zero
rouser65224083_rouser
router65025843_router
rozzer1437353_rozzer
ruder65320543_r_uder
ruer46127563_r_u_er
ruler54923343_r_uler
seizer154114573_seizer
sneezer16237963sneezer
treader84113833treader
treater74219833treater
trekker1034733trekker
trouper93811433trouper
trouser73812473trouser
truer54916643tr_u_er
tweezer19305763tweezer
ureter6313203ure_ter
wheezer22296673wheezer
wreaker143610043wreaker
wrecker16367603wrecker
wrester102812413wrester

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.390458182.1
2DLD Change Limit1340271306.56320421.6
3Display Results1301300.0462826.1
 (SQL Overall)1786911306.99925530.9
 
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.