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

274 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
robands1021986(None) 
probands13228391probands
ribands10208391ribands
roband92310721roband_
armbands1355142armbands
bands85233422__bands
browbands1743402browbands
gobangs11385832gobangs
gobans94412042goban_s
proband122710242proband_
probangs13256212probangs
rands65930452r__ands
rebinds104511872rebinds
relands85214882relands
remands104914882remands
ribalds10236672ribalds
riband9239622riband_
ribbands1344562ribbands
roads66523622ro_a_ds
roans54926442ro_an_s
robalos937682robalos
robins83617452robin_s
romanos94311482romanos
romans84620242roman_s
rounds73615622ro_unds
rowans95715342rowan_s
solands84412342solands
trolands936422trolands
abounds10217083abounds
alands75418373_alands
ands57833613___ands
armband1265983armband_
bads77048863__ba_ds
balds85524643__balds
band76740913__band_
banda85223103__banda
bandas95120543__bandas
bandy114824183__bandy
banes74945583__banes
bangs85627773__bangs
banks115527903__banks
banns75321233__banns
bans66555143__ban_s
bards87139643__bards
bauds85821043__bauds
bawds116115493__bawds
bends85628973__bends
binds86627473__binds
boards94616933bo_ards
bogans95714813bogan_s
bombards1536493bombards
bonds86126843__bonds
boranes93720403boranes
bounds94415803bo_unds
boyards13399323boyards
brands95118943_brands
brigands1245623brigands
broadbands1652913broadbands
broads94515153bro_a_ds
brogans1049663brogan_s
browband1643883browband_
bunds85523543__bunds
cabanas112413033cabanas
cobalts1139203cobalts
commands15318823commands
corbans11313173corban_s
cotans81317923cotan_s
cowards1339613cowards
cowbanes1537423cowbanes
cowbinds1634453cowbinds
cowhands1765263cowhands
croplands1445373croplands
cryobanks2042103cryobanks
demands114311413demands
deodands1144603deodands
desands94810163desands
disbands1237353disbands
dogbanes1245433dogbanes
dopants1038433dopants
dotards937253dotards
dromonds1244613dromonds
drownds12346153dro_wnds
elands74914773_elands
embanks15295703embanks
errands847603errands
expands17195733expands
fonds95824823fo__nds
founds104814193fo_unds
fronds106412343fro__nds
glands85314403_glands
goads77022853go_a_ds
goban84414073goban__
gobang10376703goban_g
gonads84511733gona_ds
gormands1266563gormands
gowans105512293gowan_s
grands84218243_grands
groans74815063gro_an_s
grounds9228313gro_unds
hands95327383__hands
hatbands1446293hatbands
hoards104912623ho_ards
hodads1147963hoda_ds
hogans105914313hogan_s
holards1148433holards
hollands12247273hollands
honans94814503honan_s
hounds104413133ho_unds
husbands1444763husbands
inlands838783inlands
islands837323islands
koans95818623ko_an_s
kobolds1474343kobolds
lands65426903__lands
ligands9438983ligands
loads65323373lo_a_ds
loans56026463lo_an_s
logans76319063logan_s
lorans65117603loran_s
lowlands1244373lowlands
moans74624373mo_an_s
monads94515303mona_ds
mounds93915133mo_unds
nomads94711603noma_ds
nonbanks1445033nonbanks
norlands936443norlands
nosebands1244083nosebands
obas65730933_oba__s
obtunds1033763_obtunds
orangs74116033_orangs
oreads73915773orea_ds
organdy1254573organdy
organs7912913organ_s
poblanos1244993poblanos
poinds93511143po_inds
ponds85323403po__nds
pounds93714383po_unds
prebends13347883prebends
prebinds13357733prebinds
probang12278383proban_g
probates12414283probates
profanes132311573profanes
prolans9314273prolan_s
propanes122415823propanes
propends13249173propends
protends113010353protends
rabatos93010903rabatos
rabats83116223raba_ts
rads56046603r__a_ds
raids65827513r__aids
rainbands1244193rainbands
rand55839573r__and_
randy95022083r__andy
ranids75118703r__anids
ranis55235833r__anis
ranks95225733r__anks
rants55935343r__ants
ratans63819373ratan_s
readds84111643r_eadds
reads64835273r_ea_ds
rebaits9312573rebaits
rebars84019833reba_rs
rebates95123183rebates
rebatos92913113rebatos
rebids94015533reb_ids
rebind94416933rebind_
reblends1135293reblends
reboards1138773reboards
rebounds1156023rebounds
recanes93222263recanes
recants93217093recants
redans75421023redan_s
refinds114512123refinds
refunds11448623refunds
regards94112563regards
rehangs1137563rehangs
reland75920433reland_
relends84013253relends
remand95618963remand_
remans84823003reman_s
remends105013033remends
reminds104614793reminds
rends65129953r__ends
repand95316063repand_
resends83513713resends
retards85015003retards
rewards114813993rewards
rewinds114810483rewinds
ribald9209293ribald_
ribband1245583ribband_
rimlands1145243rimlands
rinds64826143r__inds
ritards8439943ritards
road56332113ro_a_d_
roams74919613ro_a_ms
roan47234203ro_an__
roars55622243ro_a_rs
roasts64915413ro_asts
robalo838933roba_lo
robbed113415193robbed_
robbers112814163robbers
robbins112811063robbins
robed85323733rob_ed_
robes75133303rob__es
robin74820283robin__
robing93618003robin_g
robles85321693rob_les
roborants1145053roborants
robots8313153rob_ots
robs65837873rob___s
rodents8611543rodents
rods56442063ro___ds
romaines10512523romaines
romajis1635913romajis
roman75424823roman__
romance11311083romance
romances12310793romances
romanise10312133romanise
romano84912943roman_o
romaunts1043693romaunts
rondo65218373ro__ndo
rondos74616733ro__ndos
roods65125283ro__ods
rosins64521863rosin_s
rotas54827723rota__s
rotates72819773rotates
rotund737293rotund_
rotunda843943rotunda
rotundas943573rotundas
rouens64814443rouen_s
round64318433ro_und_
rovings11439493rovings
rowan85418733rowan__
rowens94515303rowen_s
rowings113710363rowings
royals93711263roya_ls
ruanas6311263r_uanas
rubaces1139313rubaces
rubatos9278653rubatos
rynds9569973r__ynds
ryokans1443293ryokan_s
sands65228583__sands
sarabands1245593sarabands
sobas74424253soba__s
soland75115043soland_
solanos74412853solanos
solans64122493solan_s
somans84619303soman_s
sonants7511233sonants
sounds74616183so_unds
sowans94215893sowan_s
stands75118053_stands
strands83711953strands
tabanids1144963tabanids
tabards10310383tabards
toads65621073to_a_ds
tolanes74216313tolanes
tolans64319273tolan_s
tomans85419133toman_s
towards1138783towards
troland837543troland_
unbans81912623unban_s
unbends10236993unbends
unbinds10267353unbinds
unhands1137773unhands
upbinds12234813upbinds
uplands1036943uplands
viands1047813_viands
wands96425483__wands
woads94818443wo_a_ds
woalds10427583wo_alds
womans114613653woman_s
wounds103811633wo_unds
zounds164310173zo_unds

Search took 9 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 Filter1786911340270.466383457.1
2DLD Change Limit1340272747.45317983.0
3Display Results2742740.0932946.2
 (SQL Overall)1786912748.01222302.9
 
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.