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

249 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
coeds8592016(None) 
codes86247291codes
cods76848101co_ds
coed77140541coed_
colds85726971colds
cords86030621cords
creds85418771creds
beds75937782_beds
bodes84935102bodes
bods76244712bo_ds
bolds85825282bolds
bonds86126842bonds
cades85440732cades
cads76144522c_ads
caids85226422caids
cards85137932cards
cede74928772c_ede
cedes84927332c_edes
cedi74919272c_edi
cedis84317082c_edis
cees65941592c_ees
cels65534972c_els
ceps86125952c_eps
cess65326052c_ess
chads116122232chads
chefs136214662chefs
chess105016922chess
chews135418512chews
chords125214632chords
clads85722732clads
clefs106616242clefs
clews105516332clews
clods85320862clods
clouds94612352clouds
coals76129602coals
coats75635002coats
cobbs115013992cobbs
cobs87043142co_bs
cocas95926572cocas
cocks135227162cocks
cocos95624692cocos
cod69660122co_d_
coda77029342co_da
codas84724242codas
code77347732co_de
codec107120342codec
codecs115112932codecs
coded95433182coded
coden86128542coden
codens94821012codens
coder86134222coder
coders95426982coders
codex155817582codex
coedit9316242coedit
coedits10310242coedits
coffs134916302coffs
cogs77340032co_gs
coheads13289232coheads
cohos105921852cohos
coifs105718702coifs
coils75030082coils
coins75834552coins
coirs75221052coirs
coked124730692coked_
cokes115537192cokes
colas75436772colas
cold77338772cold_
coleads102911422coleads
coled85540762coled_
coles76055062coles
coleus86818272coleus
cols66553082co_ls
colts76633292colts
comas95833002comas
combs116122962combs
comedo11359602comedo
comedos12329072comedos
comedy14378232comedy
comers105328082comers
comes97246992comes
comets105823582comets
comps115526052comps
condo85322592condo
condos94322332condos
coned86040052coned_
cones76457422cones
coneys115218422coneys
conks115525702conks
conns75024232conns
cons66057692co_ns
conus76726532conus
cooed84534342cooed_
cooees85621892cooees
cooers84324562cooers
cooeys114914482cooeys
coofs105924712coofs
cooks115429142cooks
cools75632632cools
coons76737282coons
coops96229642coops
coos67456492co_os
coots75636842coots
coped105036842coped_
copens106119962copens
copers104629842copers
copes97747102copes
cops86751372co_ps
cord76740922cord_
cored85044222cored_
corers85231072corers
cores76361852cores
corks116028272corks
corms95626222corms
corns76034762corns
corps95927042corps
cors66656442co_rs
cos510270392co__s
cosecs105015212cosecs
coses76949492coses
cosets85824402cosets
coseys115215812coseys
coss66143492co_ss
costs77231142costs
coted85033852coted_
cotes76347842cotes
cots68054842co_ts
coude85022632coude
coups95522472coups
coved115027372coved_
covens114919262covens
covers114627962covers
coves105539172coves
covets114819642covets
coveys145413502coveys
cowed115637852cowed_
cowers114625532cowers
cowls106922212cowls
cows97046642co_ws
coxed154322812coxed_
coxes145430862coxes
coyed114623802coyed_
coys97537242co_ys
cozens176314922cozens
cozes166033242cozes
cozeys204610912cozeys
cred76530882cred_
credo84815572credo
credos94612852credos
creeds94714772creeds
cress75022832cress
crews105917502crews
crowds124910762crowds
cruds85815852cruds
cuds76730472c_uds
cued76329562cued_
cues65438982cue_s
curds85725612curds
deeds75423762deeds
doers65225712doers
does56554472doe_s
eds46638922__eds
feds85234312_feds
feeds94921142feeds
feods99516852feods
foes76543442foe_s
folds95221692folds
fonds95824822fonds
foods95924162foods
fords95328182fords
geds66730812_geds
gleds75417892gleds
goads77022852goads
gods65438042go_ds
goers65520252goers
goes55644092goe_s
golds75421312golds
goods75124482goods
gowds105814042gowds
heeds95420422heeds
hods87239862ho_ds
hoed87837982hoed_
hoers85724922hoers
hoes75755732hoe_s
holds94623242holds
hoods95124082hoods
joes116635892joe_s
joeys15518042joeys
koels94613902koels
loads65323372loads
lodes66436912lodes
loess55714702loess
loids66220702loids
lords64923502lords
meds75735362_meds
meeds84920272meeds
modes85537412modes
mods77945052mo_ds
molds85324832molds
moods85224622moods
mopeds11499662mopeds
needs65719632needs
nodes64633492nodes
nods55838222no_ds
noels56418702noels
noes45845392noe_s
odds68919922_odds
odes57243242_odes
ods47546212_o_ds
oes35866192_oe_s
olds55926572_olds
ouds56430102_ouds
peds75835242_peds
pods76540152po_ds
poems95715552poems
poets76024442poets
ponds85323402ponds
poods85124752poods
reds56042862_reds
reeds65430902reeds
roads66523622roads
rodes614039082rodes
rods56442062ro_ds
roes45954142roe_s
roods65125282roods
scolds95011232scolds
seeds64330062seeds
sheds96122702sheds
sleds64418852sleds
sneds65715352sneds
sods54940212so_ds
sords64527802sords
teds54932572_teds
toads65621072toads
tods56141842to_ds
toeas55726422toeas
toed56137042toed_
toes46956442toe_s
voes75432822voe_s
voids95414672voids
weds86628932_weds
weeds95222212weeds
woads94818442woads
woes76440662woe_s
wolds95420182wolds
woods95723032woods
words95425072words
yods86531182yo_ds
zeds145821802_zeds
zoeas145815612zoeas

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.313570897.8
2DLD Change Limit538002491.64032804.9
3Display Results2492490.0633952.4
 (SQL Overall)1786912492.01688636.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.