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

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

262 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
auspex157479(None) 
aruspex1642541aruspex
apex137220212a__pex
aspen75216092a_spen
asper75520432a_sper
cusped114312042cusped
haruspex2041682haruspex
abuse77119563abus_e_
abused95614273abus_ed
abuser85413683abus_er
abuses85119103abus_es
agape85614843agape_
agapes95212413agapes
aisle55223193aisle_
aisled74516183aisled
aisles64721143aisles
aliped95414283aliped
amped104820513a_mped
amuse75920833amus_e_
amused94412513amus_ed
amuser84712623amus_er
amuses85117943amus_es
annex12310883a_nnex
ansae55720973ansae_
answer936893answer
anuses66218773anus_es
ape57251183a__pe_
aped78538153a__ped
aper66336233a__per
apes66047433a__pes
appel94615893a_ppel
apse67725383aps_e_
apses76823913aps_es
arpen74418043a_rpen
arse46539273ars_e_
arses55733873ars_es
asea46327183a_s_ea
ashed97829773a_shed
ashen87818673a_shen
ashes86230613a_shes
asked106919313a_sked
asker96418783a_sker
askew12529413a_skew
asp57235343a_sp__
aspect10612823a_spect
aspens85013353a_spens
aspers86220313a_spers
aspic95114733a_spic
aspis74618143a_spis
asps65622093a_sp_s
asses55629283a_sses
asset55932263a_sset
aster55434893a_ster
auger64922473au_ger
auklet104216833auklet
aulder7511453aulder
aurae54128113aurae_
aurei54821863au_rei
aures55137093au_res
auspice1136523auspice
auspices1236443auspices
austere7312993austere
ausubo853653ausubo
autoed7712823autoed
autopen947123autopen
axseed1456993axseed
bumped134414003bumped
bumper123714343bumper
burped116215503burped
bused85624493bus_ed
buses75936013bus_es
bushed124822383bushed
bushel114513943bushel
busher114922203busher
bushes115226113bushes
busied95117223busied
busier85219723busier
busies85525263busies
busked134917703busked
busker125517833busker
busmen1039893busmen
bussed94717053bussed
busses85023383busses
busted95123153busted
buster84726493buster
caudex1636403cau_dex
cause75225353caus_e_
caused95117043caus_ed
causer84117783caus_er
causes88026473caus_es
causey113513273caus_ey
culex144613933cu_lex
cupel9514303cu_pel
cupped134413983cupped
cupper124313863cupper
cusec94614903cus_ec
cusp86021063cusp__
cuspal1037883cuspal
cuspid11429213cuspid
cuspis105010703cuspis
cusps94913673cusp_s
cussed94917123cussed
cusser86016093cusser
cusses84522773cusses
desex13311983des_ex
dispel9310323dispel
dumped123814493dumped
dumper114615213dumper
dupe76630603du_pe_
duped95118323du_ped
duper85519003du_per
dupes86425933du_pes
duplex16386973duplex
dupped124411643dupped
dusked124112513dusked
dusted83918373dusted
duster74919723duster
funplex1932833funplex
fuse76429993fus_e_
fused94820443fus_ed
fusee86224583fus_ee
fusees95416403fusees
fusel85218493fus_el
fuses85628423fus_es
fussed104613803fussed
fusser94813773fusser
fusses94920553fusses
gasped104814293gasped
gasper94515543gasper
gausses8308693gausses
gospel936533gospel
gulped104610373gulped
gulper93410213gulper
gushed114816243gushed
gusher104115773gusher
gushes104719033gushes
gusset7316433gusset
gusted84316723gusted
hasped125014443hasped
hausen9610383haus_en
humped144015243humped
humper134115883humper
hushed134416673hushed
hushes124718593hushes
husked144212223husked
husker134212703husker
jasper154610383jasper
jauped16457903jau_ped
jumped183511553jumped
jumper173612373jumper
jupe134921003ju_pe_
jupes145218553ju_pes
justed144215773justed
juster134617013juster
lisped94113423lisped
lisper84114433lisper
lumped114216963lumped
lumpen104010663lumpen
lumper103816653lumper
lurex124816733lu_rex
lushed104218723lushed
lusher93818763lusher
lushes94022743lushes
lusted74319443lusted
luster64023673luster
mispen10312173mispen
mumped133813163mumped
mumper123513523mumper
murex145517173mu_rex
muse67136033mus_e_
mused85524583mus_ed
muser76024123mus_er
muses75134303mus_es
mushed124420843mushed
musher113820573musher
mushes114124563mushes
muskeg13338183muskeg
musket122818203musket
muskox1933953muskox
mussed94418903mussed
mussel83412903mussel
musses84624783musses
musted93321073musted
mustee83922103mustee
muster84724523muster
nausea637313naus_ea
ousel55222403ous_el
ousted73720583ousted
ouster64223733ouster
outsped101110323outsped
pauper103511943pau_per
pause75021833paus_e_
paused95114963paus_ed
pauser84415963paus_er
pauses84621473paus_es
perspex1834183perspex
pulped114612533pulped
pulper103513273pulper
pumped133915563pumped
pumper124415553pumper
pupped105013273pupped
puppet93514593puppet
puses75532203pus_es
pushed125017463pushed
pusher114318283pusher
pushes114621663pushes
pusley11379613pusley
pusses84322843pusses
rasped94715203rasped
rasper83917333rasper
rupee7321283ru_pee
ruse45938933rus_e_
ruses56136583rus_es
rushed104419863rushed
rushee93818773rushee
rusher94019653rusher
rushes94724363rushes
russet6319433russet
rusted75020923rusted
sex107043223__s_ex
spec85821973__spec
sped76031493__sped
spew95421873__spew
supe65932763su_pe_
super74924483su_per
supes75628303su_pes
supped114415703supped
supper104115433supper
suspect1158513suspect
suspend1036013suspend
sussed75015533sussed
susses64221053susses
taupe7314173tau_pe_
taupes8212673tau_pes
tumped114216233tumped
tupped114013233tupped
tushed104615893tushed
tushes94319473tushes
tusked114112153tusked
tusker104212193tusker
tusseh9448423tusseh
tusser64615833tusser
tusses64921243tusses
umped104717273_umped
unpeg8309363_unpeg
unpen72913573_unpen
unsex123512633_unsex
upped103715163_upped
upper93714263_upper
upset73222593_upset
urped84615283_urped
use36835163_us_e_
used55722823_us_ed
user45023003_us_er
uses44931113_us_es
usher84517763_usher
usnea539393_usnea
vesper1138083vesper
wisped123411893wisped
wusses93314893wusses
yauped12408333yau_ped
yauper11368543yau_per

Search took 7 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 Filter1786911127160.406440125.6
2DLD Change Limit1127162625.93618988.5
3Display Results2622620.0803275.0
 (SQL Overall)1786912626.42227824.8
 
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.