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

252 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
foin7723156(None) 
coin66645351coin
fain75840561fain
fin66458031f_in
fohn106116551fohn
foil76433911foil
foins85523381foins
fon66352271fo_n
join116724831join
loin46838721loin
agin56132712agin
ain37579092_ain
akin86328032akin
aloin55227422aloin
amin66042252amin
ayin76331742ayin
bin56658642_bin
blin67228172blin
boil66335182boil
boing84725552boing
boink115516332boink
boon67142172boon
born67338412born
brin67038192brin
cain65643912cain
chin96934742chin
cion613330912cion
coif96337912coif
coign85013912coign
coil66439652coil
coins75834552coins
coir66327242coir
colin76231692colin
con510268022co_n
coni65534802coni
conin76232722conin
conn66229132conn
coon67248942coon
corn69945812corn
covin105621122covin
din46459462_din
djin12911632djin
doing74923582doing
doit56347852doit
don46757652do_n
down86427492down
eloin55923202eloin
eon36052082eo_n
eosin55220922eosin
fagin9216572fagin
fail74840242fail
faint85837062faint
fair76332522fair
fan67158862f_an
faun76226622faun
fawn105321952fawn
feign94210712feign
feint84732252feint
fen66851352f_en
fern76129322fern
fib86344272f_ib
ficin103516722ficin
fid76847692f_id
fie67152442f_ie
fig76242832f_ig
fil65447142f_il
find87532602f_ind
fine75147952f_ine
fink117532122f_ink
fino76034692f_ino
fins75849092f_ins
fir66744892f_ir
firn76927502firn
fit66365452f_it
fix136236102f_ix
fiz156238762f_iz
flan76134182flan
flic96223732flic
fling97023512fling
flint87333502flint
flip96324262flip
flir76422202flir
flit76539272flit
florin9312652florin
flown116213992flown
foal76630922foal
foam97127172foam
fob86748332fo_b
fobs96034272fobs
foci94521012foci
foe66350812fo_e
foehn11236322foehn
foes76543442foes
fog76945562fo_g
fogie96719002fogie
fogs87035002fogs
fogy115923182fogy
foh98135892fo_h
fohns117310782fohns
foils85025812foils
foined105915012foined
foison948932foison
foist85730972foist
fold86528942fold
folia83618932folia
folic105319322folic
folio83820882folio
folk116021542folk
fond86330952fond
fons76943892fons
font77143752font
food86830572food
fool75330592fool
foot76248012foot
fop86743702fo_p
fops96532682fops
for66952072fo_r
fora75937392fora
forb97131332forb
ford86835492ford
fore78351472fore
forint9325022forint
fork115930942fork
form95836872form
fort76456442fort
foss76431642foss
fou66743782fo_u
foul77027582foul
found94917842found
fount84727032fount
four76226862four
fowl105723632fowl
fox136737862fo_x
foxing175012432foxing
foxy176517752foxy
foy96044262fo_y
foys105628292foys
fozy197017162fozy
frig85424502frig
frit77044472frit
friz166324342friz
frown115415972frown
fun66841142f_un
gain56042162gain
gin46055752_gin
going75218492going
goon57236172goon
gown85724072gown
grin55733722grin
groin65521082groin
hin67559562_hin
hon67759382ho_n
horn76735612horn
in28150862__in
iodin64419352iodin
ion36051022io_n
jin106443932_jin
john145512902john
joins125818412joins
joint125227722joint
kain85334292kain
kin76353972_kin
koan85425032koan
koi77534752koi_
koine9516482koine
kois85129402kois
lain46146282lain
lin37967372_lin
lion46334442lion
loan47436452loan
login66025002login
loid55531492loid
loins56728422loins
loon47344792loon
lorn46435252lorn
lown76929292lown
main65345522main
moan65832022moan
moil65534092moil
mon57561582mo_n
moon67140812moon
morn66237562morn
mown95424442mown
noil46133242noil
noir46722432noir
noon47134622noon
noun45724182noun
oi29061482_oi_
oil37452052_oil
oink85429342_oink
on28057182_o_n
own66429702_own
pain65647242pain
pein65834942pein
pin57066722_pin
pion67235292pion
poi57244662poi_
poind84217912poind
point75338732point
pois66539042pois
poon67341262poon
porn65636022porn
pyin96823232pyin
quin135823922quin
quoin144012322quoin
rain46251732rain
rein46040892rein
rin36663182_rin
roan47234202roan
robin74820282robin
roil46235292roil
rosin55325312rosin
ruin47430512ruin
sain45551292sain
shin75634312shin
sin36265892_sin
skin85927532skin
soil46138832soil
son37761952so_n
soon46240502soon
sorn46641062sorn
sown75127452sown
sozin14514542sozin
spin66231302spin
tain45548072tain
thin76732392thin
tin36362172_tin
toil46536282toil
toit46353062toit
ton310265102to_n
toon47740632toon
torn46044252torn
town76928702town
toxin124716712toxin
twin76023082twin
tyin76424002tyin
vain75233002vain
vein75625752vein
void86220562void
wain75840202wain
whin105225692whin
win66456292_win
won66252062wo_n
worn75631752worn
yin67648732_yin
yogin98317742yogin
yon67348952yo_n
yoni77524392yoni
zein135620602zein
zin125643772_zin
zoic152316072zoic
zoon137326982zoon

Search took 3 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.516346300.4
2DLD Change Limit298722521.45320558.8
3Display Results2522520.0634000.0
 (SQL Overall)1786912522.03287938.5
 
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.