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

204 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
loids6622071(None) 
lids56336471l_ids
loads65323371loads
loid55531501loid_
loins56728421loins
lords64923501lords
sloids73712691sloids
voids95414681voids
acids87121012acids
aids57846372_aids
alcids94812292alcids
aloins65022202aloins
amids85627522amids
aroids75118222aroids
avoids104410202avoids
bids75838462_bids
blonds95213342blonds
bloods94614842bloods
bods76244722bo_ds
boils75427192boils
bolds85825282bolds
bonds86126842bonds
bovids1287972bovids
caids85226432caids
clods85320862clo_ds
clouds94612352clouds
cods76848112co_ds
coeds85920162coeds
coifs105718702coifs
coils75030082coils
coins75834552coins
coirs75221052coirs
colds85726972colds
cords86030622cords
doits66223672doits
droids84712582droids
eloins65419382eloins
fids87034752_fids
floods104511652floods
fluids10349422fluids
foils85025812foils
foins85523382foins
folds95221692folds
fonds95824822fonds
foods95924162foods
fords95328182fords
geoids8369842geoids
gids65933752_gids
goads77022852goads
gods65438052go_ds
golds75421312golds
goods75124482goods
gowds105814042gowds
grids75321402grids
guids75516162guids
haloids113012552haloids
hods87239872ho_ds
holds94623242holds
hoods95124082hoods
hyoids1377672hyoids
ids47535482__ids
imids86015152imids
iodids83711152iodids
irids66417782irids
joins125818412joins
keloids1288662keloids
kids96029652_kids
kois85129412koi_s
lads56549142l_ads
laics76419252laics
laid56439152laid_
lairds74711612lairds
lairs55425872lairs
lands65426902lands
lards65331862lards
lauds65618482lauds
leads66028492leads
leis45739602lei_s
lends65326252lends
leuds66214812leuds
libs66732772l_ibs
lid47453532l_id_
lido56028172l_ido
lidos65219892l_idos
lies46454202l_ies
lins47059062l_ins
lions55923212lions
lipids94310922lipids
lipoids1038232lipoids
lips67141452l_ips
lis37162282l_i_s
lits46252502l_its
load56730602load_
loafs85616992loafs
loams75619862loams
loans56026462loans
lobes75331002lobes
lobos75921842lobos
lobs66441082lo_bs
lochs106715512lochs
locks115126922locks
locos75822602locos
locus74819992locus
lode56240122lo_de
lodes66436912lodes
loess55714702loess
lofts85518362lofts
loges66534202loges
logics95711122logics
logins77820642logins
logos67225332logos
logs57343112lo_gs
loided83414022loided
loin46838722loi_n
lolls512121732lolls
longs65527062longs
loofs85623782loofs
looies65025832looies
looks95124862looks
looms75124642looms
loons55731722loons
loops75723962loops
loos49051122lo_os
loots55431422loots
lopes76437342lopes
lops66043352lo_ps
lord55032082lord_
lores55045402lores
lories64933042lories
loris55329152loris
loses56742012loses
loss45337962lo_ss
lotas55926302lotas
lotos54724632lotos
lots47652092lo_ts
lotus55718062lotus
loud55228042loud_
louies64525102louies
louis57322322louis
loups75319622loups
lours55125292lours
louts56330272louts
loves85332012loves
lowes85732462lowes
lows75843012lo_ws
loxes125227472loxes
maids86327152maids
meloids10911452meloids
mids76541802_mids
mods77945062mo_ds
moils76125752moils
molds85324832molds
moods85224622moods
nods55838232no_ds
noils55024332noils
noirs55615462noirs
odds68919932_odds
ods47546222_o_ds
oils46337982_oils
olds55926582_olds
olios54520852olios
ootids71110352ootids
ouds56430112_ouds
ovoids10456922ovoids
oxids13128972oxids
plaids94312442plaids
plods85719292plo_ds
ploidy1237482ploidy
pods76540162po_ds
poinds93511142poinds
pois66539042poi_s
ponds85323402ponds
poods85124752poods
qaids156116322qaids
quids154917472quids
raids65827522raids
rids56539562_rids
roads66523622roads
rods56442072ro_ds
roils54826792roils
roods65125282roods
saids65328862saids
skids104615342skids
sloid64619712sloid_
slojds14345472slojds
sloyds10346292sloyds
sods54940222so_ds
soils55327982soils
solids74116402solids
sords64527802sords
toads65621072toads
tods56141852to_ds
toils54527492toils
toits55327472toits
vids85627552_vids
void86220572void_
whids125413992whids
woads94818442woads
wolds95420182wolds
woods95723032woods
words95425072words
yids85224972_yids
yods86531192yo_ds
zooids1637092zooids

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 Filter178691538000.296603685.8
2DLD Change Limit538002042.06326078.5
3Display Results2042040.0633238.1
 (SQL Overall)1786912042.42273778.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.