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

265 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
exurbs153442(None) 
exurb1457701exurb_
blurbs10489312blurbs
burbs95423492_burbs
curbs94821652_curbs
enures63919712enures
euros54920242e_uros
exerts133712292exerts
extras13310222extras
exudes143710362exudes
exults13257632exults
exurban1653502exurban
exurbia1643442exurbia
exurbias1743652exurbias
slurbs8439742slurbs
urbs65922052__urbs
arbs66834733__arbs
auras55932553_auras
aures55137093_aures
auris55331523_auris
azures15510183azures
barbs95928193_barbs
bedumbs1433633bedumbs
benumbs1333543benumbs
blubs95818153blu_bs
blurb95214903blurb_
blurs74619083blur_s
blurts84412643blurts
bourgs9459993bourgs
bourns84114063bourns
bubs86235493_bu_bs
bulbs96016933_bulbs
buras74736293_buras
burb85334673_burb_
burds84626063_burds
burgs84924093_burgs
burls74228853_burls
burns74926773_burns
burps94220173_burps
burrs74925653_burrs
burs65847423_bur_s
carbs96031463_carbs
cesuras958683cesuras
chubs125412623chu_bs
churls115411073churls
churns114910233churns
churrs115111513churrs
clubs95415103clu_bs
courts84216163courts
crumbs12409233crumbs
cubs85832383_cu_bs
curb86732223_curb_
curds85725613_curds
cures75645433_cures
curfs105122143_curfs
curls74927103_curls
curns74924273_curns
currs75624393_currs
curs65645543_cur_s
darbs85323263_darbs
daubs85014563dau_bs
demurs939773demur_s
desorbs10437713desorbs
douras75016723douras
drubs85913833dru_bs
dubs78432193_du_bs
dumbs105915753_dumbs
duras65727723_duras
dures65635923_dures
durns64819863_durns
duros65422693_duros
durrs65519993_durrs
eagres74014573eagres
earls56127513e_arls
earns55927563e_arns
ears46356593e_ar_s
ebbs82411983e__bbs
ecrus75113863e_crus
ecus65421463ecu__s
educes94011953educes
educts9439893educts
egers65120373eger_s
eludes75417683eludes
elutes64020313elutes
emirs76116153emir_s
emus66821683emu__s
endures83314603endures
enduros8298153enduros
ensures73315903ensures
enure53520223enur_e
enured73315333enured
equals1538693equals
equids16439143equids
equips17387193equips
eras45441503e__ras
ergs55523813e__rgs
erns45428223e__rns
eros45238453e__ros
errs45622533e__rrs
ers36046283e__r_s
eructs83610793eructs
erugos7347343erugos
erupts8348903erupts
estrus61912113estrus
etudes73811603etudes
etuis54013133etu_is
euro45325273e_ur_o
everts94514893everts
ewers86018823ewer_s
exacts15359613exacts
exalts13328313exalts
exams14199083ex_ams
exarch18196173exarch
exarchs19165193exarchs
excels1536663excels
excess1546053excess
excursus1742593excursus
excuses1638903excuses
execs14539723ex_ecs
exert124624143exer_t
exes116530813ex__es
exhorts1746313exhorts
exhumes1934323exhumes
exiles134816403exiles
exines135715803exines
exists134710913exists
exits125515913ex_its
exodos1435943exodos
exodus1434653exodus
exons125813343ex_ons
expats1537683expats
expels1547173expels
experts1659063experts
expires1638683expires
exports1647983exports
expos1449203ex_pos
express1637493express
exserts1467013exserts
externs1438233externs
extols1337683extols
extorts1447753extorts
extra1239003extr_a
exude134010293exu_de
exuded15317683exuded
exult122814123exu_lt
exuvia1644223exuvia
eyers86521333eyer_s
eyras84715923e_yras
eyres84921773e_yres
femurs1136713femur_s
fixures17596063fixures
flexures1843423flexures
flubs105515443flu_bs
forbs105720803_forbs
fours85521493four_s
fubs96328793_fu_bs
furls85322053_furls
furs76735043_fur_s
garbs86321413_garbs
gaurs66317993gaur_s
gourds8108253gourds
grubs86312603gru_bs
gurus64318193_gurus
herbs105520503_herbs
hexers165612753hexer_s
houris94514563houris
hours85422383hour_s
hubs96027143_hu_bs
hurds95219073_hurds
hurls86522713_hurls
hurts86922823_hurts
inures63318953inures
inurns63310983inurns
ixoras1337193ixoras
kauris103611523kauris
kerbs115013673_kerbs
knurls10396243knurls
knurs94511153knur_s
kouros1039183kouros
kurus98015633_kurus
lauras63414333lauras
lemures938793lemures
lemurs837253lemur_s
lours55125293lour_s
lures56138533_lures
lurks95218743_lurks
mourns84111013mourns
muras75329563_muras
mures75937213_mures
murks114821723_murks
murrs75521293_murrs
nexus124710663nexu__s
nexuses1436743nexuses
nubs65927143_nu_bs
numbs94913093_numbs
nurds65518523_nurds
nurls55519683_nurls
orbs66626253__orbs
ours47237563_our_s
perturbs1244363perturbs
plumbs12459333plumbs
pours74623183pour_s
pubs85029213_pu_bs
puris75332023_puris
purls74723353_purls
purrs75320433_purrs
purs65641043_pur_s
recurs83315803recur_s
redubs9358383redu_bs
resorbs95010523resorbs
returns79712593returns
reverbs12368863reverbs
rhumbs13366773rhumbs
rubs66133493_ru_bs
scrubs104210313scrubs
scurfs113210813scurfs
secures9613163secures
shrubs11409213shrubs
slubs74719533slu_bs
slurb74116323slurb_
slurps84410003slurps
slurs54123373slur_s
snubs75412553snu_bs
sorbs75022103_sorbs
sours55230503sour_s
spurns84811383spurns
spurs74621523spur_s
spurts84814973spurts
squabs17429323squabs
squibs17317443squibs
stubs75016073stu_bs
sturts63915143sturts
subs66037123_su_bs
suburbs1136503suburbs
suras55336323_suras
surds65624663_surds
surfs85022543_surfs
tenures7412013tenures
textures1597523textures
thumbs13377443thumbs
thurls9418713thurls
tours55325863tour_s
tsuris62710203tsuris
tubs65430063_tu_bs
turbo71015043_turbo
turbos8910783_turbos
turds65021693_turds
turfs84620443_turfs
turks95320823_turks
turns55623233_turns
turps74918733_turps
tzuris15286913tzuris
uncurbs1134913uncurbs
urb55731103__urb_
urds55922423__urds
urns46323893__urns
urps66920473__urps
urus46426133__urus
usurps8105073usurps
velures1039093velures
verbs104614393_verbs
vexers165210403vexer_s
xerus12313333_xerus
yours85217873your_s
yurts87216533_yurts

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.1401276364.3
2DLD Change Limit1127162656.14018357.7
3Display Results2652650.0803312.5
 (SQL Overall)1786912656.36028096.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.