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

298 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
rurban84904(None) 
turban8310481turban
urban72013861_urban
buran75225302bur_an
corban10314692corban
curran8312022curran
durbar968722durbar
durian7312002durian
exurban1653502exurban
furan84320012fur_an
kurgan11126782kurgan
lurdan738362lurdan
reran57329102rer_an
rumba93612512rumba_
rumbas102512012rumbas
rural55821172rur_al
slurban944862slurban
turbans939562turbans
unban72114332_unban
urbane82211382_urbane
airbag956963airbag
airman82414223airman
ameban1039093ameban
anuran64313243anur_an
aura45836253aur_a_
aurae54128113aur_ae
aural54428963aur_al
aurar54420253aur_ar
auras55932563aur_as
ban58366843___ban
barbal104016663barbal
barman103519703barman
bourbon1135813bourbon
bran65740383_br_an
bubal94218213bu_bal
bubba84311803bubba_
bubbas94110703bubbas
bugbane1255863bugbane
bulbar1039583bulbar
bura66139533bur_a_
burans85019303bur_ans
buras74736303bur_as
burb85334673burb__
burble104617703burble
burbly134311153burbly
burbot10815653burbot
burbs95423493burb_s
burden9412473burden
bureau8712523bureau
burial84117623burial
burin75626063bur_in
burka114617693burka_
burkas124513803burkas
burlap1098353burlap
burn65636433bur__n
burqa165013093burqa_
burqas174410903burqas
bursa74921523bursa_
bursae84515603bursae
bursal84414823bursal
bursar85413253bursar
bursas85318273bursas
burton8311273burton
busbar1038453busbar
busman10310253busman
carbarn1139453carbarn
carbon104919043carbon
carman103920743carman
corbans11313173corbans
courlan9117763courlan
crucian1146283crucian
crura7312583crur_a_
crural8610633crur_al
curb86732223curb__
curbed114615873curbed
curber104517053curber
curbing123814023curbing
curbs94821653curb_s
curia74523773curia_
curiae84518373curiae
curial84019153curial
curn66731893cur__n
currans9310613currans
currant9314173currant
curtain9319793curtain
curtal83914543curtal
cutbank1545533cutbank
darbar959953darbar
dubbin11329263dubbin
dura55232113dur_a_
dural64923893dur_al
duras65727733dur_as
durbars1077973durbars
durians839573durians
durion7510963durion
durn56127633dur__n
durra65315793durra_
durras74713373durras
ferbam1339003ferbam
firman112211343firman
forbad122710503forbad
fubar1039923fu_bar
furane94015493fur_ane
furans94515953fur_ans
german9611983german
goban84414073_goban
gran56335013_gr_an
groan65618423_groan
guan55325583gu__an
gunman9299453gunman
herbal112513493herbal
human102716033hu_man
hurrah12369183hurrah
hurray12459913hurray
husband1345653husband
inurbane1045253inurbane
jordan1468063jordan
juba134916983ju_ba_
jubas144614223ju_bas
jubbah2034353jubbah
jumbal1758463jumbal
jura116024893jur_a_
jural125120483jur_al
jurant134216553jur_ant
jurat124829323jur_at
juryman1943583juryman
kanban1238623kanban
kurbash1643803kurbash
kurgans12145653kurgans
kurta95113913kurta_
kurtas10349883kurtas
loran55925093lor_an
lumbar103610593lumbar
lungan74710213lungan
lurdane835983lurdane
lurdans837073lurdans
merman10513863merman
morgan9311373morgan
mura65633303mur_a_
mural75225113mur_al
muras75329583mur_as
murein8311763murein
murra74519083murra_
murrain937763murrain
murras84916013murras
nonurban1044853nonurban
nubbin10308293nubbin
numbat10312083numbat
organ6915393_organ
ouabain944943ouabain
ourang73311063our_ang
outman83115033outman
outran63218893outran
parian83223963parian
partan83820563partan
purana8712933pur_ana
purda82914693purda_
purdah12288753purdah
purdas92612263purdas
purin75527593pur_in
puritan939283puritan
purlin83615863purlin
pyran10514473pyr_an
quartan1636423quartan
quean143612843qu_ean
rabat72832223r_abat
rabbin103112303rabbin
radian74117273radian
ragbag1045463ragbag
raglan73711503raglan
ragman94013713ragman
ran38266623__r_an
randan7315253randan
ratan53722663r_atan
ratbag956563ratbag
rattan63613603rattan
rebar75420193r_ebar
redan66125013r_edan
redbay1238333redbay
reloan6415693reloan
reman75730153r_eman
replan83215823replan
reread71715433reread
rerun58722153rer_un
rewan85623663r_ewan
rhumba13375553rhumba_
rhumbas14305163rhumbas
riband9239623r_iband
ribband1245583ribband
ribbon1036533ribbon
roan47234203__roan
roband92310723r_oband
robbin103611183robbin
robin74820283r_obin
rodman949713rodman
roman75424823r_oman
rowan85418733r_owan
ruana5312423ru__ana
ruanas6311263ruanas
rub56342823ru_b__
rubace10310173ru_bace
rubati8299693ru_bati
rubato8319683ru_bato
rubbed114515083rubbed
rubber104715793rubber
rubbing123412273rubbing
rubble104315673rubble
rubbly133710613rubbly
rubby124413863ru_bby
rube65532013ru_b_e
rubel75416833ru_bel
rubes74928413ru_bes
ruble74521253ru_ble
rubric1097823rubric
rubs66133493ru_b_s
rubus76415063ru_bus
ruby97819943ru_b_y
ruffian1344133ruffian
ruga56121233ru_ga_
rugae65114763ru_gae
rugal65916093ru_gal
rugby11448133rugb_y
ruin47430513ru__in
rumbaed12287493rumbaed
rumbaing13185303rumbaing
rumble103718813rumble
rumbly134412163rumbly
rumen74419503ru_men
rumina83412483rumina
run36244993ru___n
runback1556603runback
runway12105973runway
rupiah1146213rupiah
rutin55421343ru_tin
ryokan1353753ryokan
saran53730303sar_an
saurian739913saurian
suba64926603su_ba_
subah106015213su_bah
subas74724073su_bas
suburban1244453suburban
suldan72611043suldan
sultan63012593sultan
suntan62613003suntan
sura45740293sur_a_
surah86823253sur_ah
sural55931263sur_al
suras55336333sur_as
surbase939793surbase
surfman1236203surfman
surra55521343surra_
surras65919533surras
surtax1337843surtax
tarpan82814293tarpan
tartan64217513tartan
tarzan152910753tarzan
tuba65422363tu_ba_
tubae74716643tu_bae
tubal75517203tu_bal
tubas75119583tu_bas
turbaned1145623turbaned
turbary1236383turbary
turbid979713turbid
turbine9310303turbine
turbit8715113turbit
turbo71015043turb_o
turbofan1342593turbofan
turbos8910783turbos
turbot8914263turbot
tureen63312723tureen
turfman1243983turfman
turion6313163turion
turn46330393tur__n
turnon638193turnon
uhlan849113_uhlan
ulan46527393_u_lan
ulpan7310123_ulpan
unbans81912623_unbans
unbar71913613_unbar
unman72715423_unman
urb55731113_urb__
urbaner9177133_urbaner
urbia7311143_urbia
urbias839093_urbias
urbs65922063_urb_s
urea46528063_urea_
ureal56722683_ureal
ureas55826013_ureas
urial54823023_urial
urn35731473_ur__n
ursa44116913_ursa_
ursae55214453_ursae
verbal112513663verbal
yerba101010763yerba_
yerbas11119293yerbas
yuan76120013yu__an
yulan8411493yu_lan
yurta86014253yurta_

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.390458182.1
2DLD Change Limit1127162985.58020200.0
3Display Results2982980.0933204.3
 (SQL Overall)1786912986.06329472.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.