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

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

203 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
koans9581862(None) 
kaons95014851kaons
khans124615171khans
koan85425031koan_
koas85635091koa_s
loans56026461loans
moans74624371moans
roans54926441roans
alans55636172alans
azans146516882azans
bans66555142_bans
beans75734692beans
boars75229602boars
boas66150832boa_s
boats75635152boats
bogans95714812bogans
boons75031912boons
brans75437432brans
cans65050852_cans
clans75031012clans
coals76129602coals
coats75635002coats
coins75834552coins
conns75024232conns
cons66057692co_ns
coons76737282coons
corns76034762corns
cotans81317922cotans
cyans105714812cyans
dans56748152_dans
deans66131392deans
doats65224882doats
donas65926472donas
dons56048702do_ns
downs94918572downs
elans55527752elans
eons46638712eo_ns
fans76247372_fans
flans85327972flans
foals85721692foals
foams105017952foams
fohns117310782fohns
foins85523382foins
fons76943892fo_ns
glans65125832glans
goads77022852goads
goals65521292goals
goas55239942goa_s
goats65527302goats
gobans94412042gobans
goons65326772goons
gowans105512292gowans
gowns95115102gowns
grans64832542grans
groans74815062groans
guans64419442guans
hoars85925552hoars
hogans105914312hogans
honans94814502honans
hons77350782ho_ns
horns86125332horns
ikons96311012iko_ns
ions46737852io_ns
jeans126022112jeans
johns15398712johns
joins125818412joins
kaas86531842k_aas
kabs107130842k_abs
kaes85734062k_aes
kafs116423742k_afs
kains96125642kains
kana85928532k_ana
kanas95326912k_anas
kane85133972k_ane
kanes95529372k_anes
kaon87521022kaon_
karns96624142karns
kas77058582k_a_s
kats85944332k_ats
kays116032192k_ays
kbars114612602kbars
keas86337092kea_s
keens95721182keens
kens85435232k_ens
kerns94719562kerns
khafs15648842khafs
khan115819142khan_
khats125316012khats
kiang104811352kiang
kiangs11378362kiangs
kilns95112982kilns
kinas95626912kinas
kins85747912k_ins
kirns95315452kirns
knaps115511172knaps
knars94416112knars
knowns13426442knowns
koa76737772koa__
koala95112212koala
koalas104011662koalas
kobos115616892kobos
kobs105831082ko_bs
koels94613902koels
kohls12437802kohls
koine9516482koine
koines10415732koines
kois85129402ko_is
kojis16468442kojis
kolas94822232kolas
kolos94921212kolos
konk79320612ko_nk
konks84917112konks
kooks85217262kooks
kophs145010932kophs
kops107031292ko_ps
koras95927112koras
korats105416062korats
kors85933012ko_rs
kos76944822ko__s
koss85224812ko_ss
kotos95717702kotos
kroons103711242kroons
kvas117015942kva_s
kvass12507272kvass
kyaks11459162kyaks
kyars124813962kyars
kyats125012442kyats
leans55536252leans
loads65323372loads
loafs85616992loafs
loams75619862loams
loan47436452loan_
logans76319062logans
loins56728422loins
loons55731722loons
lorans65117602lorans
mans66354552_mans
means75831232means
moan65832022moan_
moas65545342moa_s
moats75827642moats
monas74732152monas
mons68152262mo_ns
moons75331002moons
morns75527442morns
naans55815252naans
nans46139402_nans
nonas55126652nonas
noons54125282noons
nouns56717312nouns
oafs76425262_oafs
oaks86527902_oaks
oars46846032_oars
oats46554212_oats
okas85225392oka_s
okays12609442okays
ons36148512_o_ns
owns76819582_owns
pans65855732_pans
peans75437642peans
pians75126962pians
plans75731272plans
pons65850602po_ns
poons75430972poons
porns75527342porns
roads66523622roads
roams74919612roams
roan47234202roan_
roars55622242roars
romans84620242romans
rowans95715342rowans
sans45153362_sans
scans74625102scans
skeans104512912skeans
skoals10438242skoals
soaks95220292soaks
soaps75120712soaps
soars54732512soars
solans64122492solans
somans84619302somans
sons46049552so_ns
sorns55028422sorns
sowans94215892sowans
spans74528732spans
swans84625012swans
tans46154822_tans
toads65621072toads
tolans64319272tolans
tomans85419132tomans
tons46553052to_ns
toons55027532toons
towns86018882towns
trans54933042trans
ulans54921302ulans
vans76236732_vans
wans76452272_wans
weans85326742weans
woads94818442woads
womans114613652womans
wons74942042wo_ns
yeans86624882yeans
yuans84613322yuans
zoons144919692zoons

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 Filter178691538000.310576422.6
2DLD Change Limit538002031.58034050.6
3Display Results2032030.0603383.3
 (SQL Overall)1786912031.95091636.4
 
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.