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

(Change Limit cannot be increased to the length of your word, because then every letter could be different!)
to automatically increase the Change Limit after seconds.

92 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
kohl11391171(None) 
koel84519941koel
kohls12437801kohls
boho96923322boho
boil66335182boil
boll65634752boll
bowl96827702bowl
buhl95518222buhl
coal66939252coal
coho97524492coho
coil66439652coil
col59360352co_l
cool66940492cool
cowl97530812cowl
dahl87019222dahl
dol47150652do_l
doll56632492doll
foal76630922foal
foh98135892foh_
fohn106116552fohn
foil76433912foil
fool75330592fool
foul77027582foul
fowl105723632fowl
goal55829302goal
howl107625692howl
john145512902john
jowl146120302jowl
kail85131492kail
keel85729462keel
khi106318302k_hi
kill85533172kill
knoll9389602knoll
koa76737772ko_a
koala95112212koala
koan85425032koan
koas85635092koas
kob99442382ko_b
kobo107422102kobo
kobs105831082kobs
koels94613902koels
koi77534742ko_i
kois85129392kois
koji155611112koji
kola85124962kola
kolo87026222kolo
konk79320612konk
kook75822602kook
kop97440202ko_p
koph135816542koph
kophs145010932kophs
kops107031292kops
kor76538892ko_r
kora86431552kora
kore85834162kore
kors85933012kors
kos76944822ko_s
koss85224812koss
koto86323462koto
loll46128382loll
mohel104914832mohel
moil65534082moil
mol56654592mo_l
moll66735702moll
mool67533862mool
noel45226552noel
noh66640642noh_
noil46133242noil
oh57447002_oh_
ohm86523012_ohm
oho66534382_oho
ohs66232312_ohs
oil37452052_oil
ooh67637092ooh_
oohs75220692oohs
owl66228972_owl
poh86740532poh_
pol56449382po_l
poll66332132poll
pool65835952pool
roil46235292roil
roll46331652roll
rotl45029682rotl
skoal93811452skoal
soil46138822soil
sol37256622so_l
soul46435712soul
toil46536282toil
toll45535262toll
tool46735682tool
wool76427372wool
yowl105820952yowl

Search took 2 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 Filter178691298720.0762351197.4
2DLD Change Limit29872921.00029872.0
3Display Results92920.0165750.0
 (SQL Overall)178691921.092163636.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.