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

256 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
loid5553149(None) 
laid56439141laid
lid47453521l_id
load56730601load
loids66220701loids
loin46838721loin
lord55032081lord
loud55228041loud
sloid64619711sloid
void86220561void
acid77533392acid
aid49269082_aid
alcid85817972alcid
algid75415582algid
algoid83011472algoid
aloin55227422aloin
aloud65018072aloud
amid77036352amid
arid57642712arid
aroid65428342aroid
avid88325962avid
avoid95516682avoid
bid67751812_bid
blond85618372blond
blood85319522blood
bod67055542bo_d
boil66335182boil
bold75432812bold
bond75334362bond
bovid111011622bovid
caid77837532caid
chid106626402chid
clod76124612clo_d
cloud86716422cloud
cod69660122co_d
coed77140542coed
coif96337912coif
coil66439652coil
coin66645352coin
coir66327242coir
cold77338772cold
cord76740922cord
did56850522_did
doit56347852doit
droid74218542droid
eloin55923202eloin
fid76847692_fid
flood95215602flood
florid10311452florid
fluid94013962fluid
foil76433912foil
foin77231562foin
fold86528942fold
fond86330952fond
food86830572food
ford86835492ford
geoid74215762geoid
gid57047272_gid
goad66830982goad
god57449792go_d
gold65430162gold
good66531802good
gowd96519982gowd
grid65829612grid
guid66022822guid
haloid104317762haloid
hid76248382_hid
hod76852462ho_d
hoed87837982hoed
hold86235062hold
hood85132332hood
hyoid12612442hyoid
id38941842__id
imid76122292imid
iodid74315532iodid
irid55927172irid
join116724832join
keloid11812622keloid
kid86540622_kid
koi77534752koi_
kois85129402kois
lad48165702l_ad
laic65931562laic
lain46146282lain
lair45934152lair
laird65417792laird
land56337312land
lard56742002lard
laud56527722laud
lead56038852lead
led46254552l_ed
lei36846382lei_
leis45739602leis
lend56233672lend
leud57223422leud
lewd85716592lewd
li29948752l_i_
lib57750272l_ib
lido56028162l_ido
lids56336462l_ids
lie38264522l_ie
lied55838092lied
lin37967372l_in
lion46334442lion
lip514755802l_ip
lipid85916172lipid
lipoid9411042lipoid
lis37162272l_is
lit39377312l_it
livid96714422livid
lo28053442lo__
loads65323372loads
loaf76734902loaf
loam65630482loam
loan47436452loan
lob57154462lo_b
lobe65535362lobe
lobed86022132lobed
lobo67229862lobo
lobs66441082lobs
loca65527682loca
loch95527132loch
loci66126282loci
lock106134362lock
loco67030742loco
lode56240112lode
loft76539142loft
log46252682lo_g
loge56837192loge
logia68116602logia
logic88217832logic
login66025002login
logo57931762logo
logs57343112logs
logy87025782logy
loided83414022loided
loins56728422loins
loll46128382loll
lone45849132lone
long56933342long
loo38359822lo_o
looed64626132looed
loof78141052loof
looie55624242looie
look87333472look
loom67035052loom
loon47344792loon
loop67835012loop
loos49051122loos
loot46955822loot
lop58255312lo_p
lope65941922lope
loped85128332loped
lops66043352lops
lords64923502lords
lore45850352lore
loris55329152loris
lorn46435252lorn
lory75931712lory
lose45144582lose
loss45337962loss
lost47951492lost
lot38179262lo_t
lota47233502lota
loth76132132loth
loti46431842loti
lotic76420672lotic
lots47652092lots
louie55023512louie
louis57322322louis
loup66028432loup
lour45430682lour
lout45952142lout
love75234762love
loved95021362loved
low66051872lo_w
lowe75435312lowe
lowed95233902lowed
lown76929292lown
lows75843012lows
lox108240962lo_x
loxed135017052loxed
lucid84314572lucid
lurid64618972lurid
maid75537662maid
meloid9616002meloid
mid67354472_mid
mod69054402mo_d
modi76826312modi
moil65534092moil
mold76034332mold
mood76332062mood
myoid11512992myoid
nod47549562no_d
nodi56626742nodi
noil46133242noil
noir46722432noir
od39255242_o_d
odd57725452_odd
oi29061482_oi_
oil37452052_oil
old47033462_old
olio46829672olio
ootid61416702ootid
oud47439072_oud
ovoid94811022ovoid
oxid12815482oxid
paid75737482paid
plaid85118302plaid
plod76723272plo_d
ploidy1237482ploidy
pod66351482po_d
poi57244662poi_
poind84217912poind
pois66539042pois
pond75530492pond
pood75934322pood
pyoid11513762pyoid
qaid146023842qaid
quid144922352quid
raid55243072raid
rid46754632_rid
road56332112road
rod47953892ro_d
roil46235292roil
rood56733002rood
said55742112said
skid95720932skid
slid55828982slid
sloids73712692sloids
slojd13378842slojd
sloyd9409682sloyd
sod46053702so_d
soil46138832soil
sold54837412sold
solid65025082solid
sord56237202sord
toad55830182toad
tod49457072to_d
toed56137042toed
toil46536282toil
toit46353062toit
told56132202told
vid77241812_vid
voids95414672voids
whid115418872whid
woad85523942woad
wold85429072wold
wood85329382wood
word89832002word
xyloid1738192xyloid
yid76640832_yid
yod77545502yo_d
yond86122312yond
zoic152316072zoic
zooid15312102zooid

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.356501941.0
2DLD Change Limit298722561.30022978.5
3Display Results2562560.1232081.3
 (SQL Overall)1786912561.779100444.6
 
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.