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

344 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
robes7513330(None) 
lobes75331001lobes
obes66036831_obes
probes104119451probes
ribes75530171ribes
robe65335641robe_
robed85323731robed
robles85321691robles
robs65837871rob_s
rodes614039081rodes
roes45954131ro_es
roles56747981roles
ropes75940061ropes
roses56445771roses
rotes56143901rotes
roues56039351roues
roves84834481roves
rubes74928411rubes
abbes96723522abbes
adobes94411522adobes
aerobes9311492aerobes
babes95834112babes
bes56557432__bes
bobs86340652bob_s
bodes84935102bodes
boles75448602boles
bombes124916822bombes
bones76446532bones
bores76448252bores
boxes145625072boxes
bribes105918532bribes
bromes104719762bromes
broses86524402broses
cobbs115013992cobbs
cobles104622882cobles
cobs87043142cob_s
codes86247292codes
cokes115537192cokes
coles76055062coles
combes125321732combes
comes97246992comes
cones76457422cones
copes97747102copes
cores76361852cores
coses76949492coses
cotes76347842cotes
coves105539172coves
coxes145430862coxes
cozes166033242cozes
crones84729242crones
crores86121162crores
crozes174417662crozes
cubes95028162cubes
dobies94422092dobies
does56554472do_es
doges75630162doges
doles67843752doles
domes85735562domes
dopes84935042dopes
doses65938502doses
dotes65836692dotes
doves94728152doves
dozes155226302dozes
drones75023432drones
droves105116672droves
enrobes92211112enrobes
erodes74819882erodes
eroses65327052eroses
fobs96034272fob_s
foes76543442fo_es
fores85847102fores
foxes156321092foxes
froes86126692fro_es
gibes84422522gibes
globes94314542globes
gobies95418062gobies
goboes95914442goboes
gobos86219372gobos
gobs76935572gob_s
goes55644092go_es
gores65740372gores
goxes135018262goxes
grebes93813612grebes
gropes95220402gropes
groves104318102groves
gybes115012722gybes
hebes105521672hebes
hoboes114717442hoboes
hobos106321352hobos
hobs97038982hob_s
hoes75755732ho_es
hokes126231642hokes
holes84748652holes
homes106938812homes
hones88144492hones
hopes105835642hopes
hoses85443172hoses
howes114730262howes
irones64724012irones
jibes145520322jibes
jobs136529432job_s
joes116635892jo_es
jokes165423332jokes
joles125230832joles
jones125028182jones
jubes145420742jubes
kibes115521112kibes
kobos115616892kobos
kobs105831082kob_s
lobe65535362lobe_
lobed86022132lobed
lobos75921842lobos
lobs66441082lob_s
lodes66436912lodes
loges66534202loges
lopes76437342lopes
lores55045402lores
loses56742012loses
loves85332012loves
lowes85732462lowes
loxes125227472loxes
lubes74727992lubes
mabes96331532mabes
mobs85737372mob_s
modes85537412modes
mokes114631032mokes
moles74747922moles
momes95134472momes
mopes95134982mopes
mores76249642mores
motes75944002motes
moues75732842moues
moves106128422moves
nabes75427092nabes
nobles83319722nobles
nobs66436902nob_s
nodes64633492nodes
noes45845392no_es
nomes74933122nomes
nones55639132nones
noses55435642noses
notes55034582notes
obas65730932_obas
obe56638642_obe_
obese75212422_obese
obey96521302_obey
obeys107010642_obeys
obis66226842_obis
oboes75717712_oboes
odes57243242_odes
oes35866192_o_es
okes84936342_okes
oles46453472_oles
ones46146532_ones
oozes145418712oozes
opes65942612_opes
orbed85516192orbed
orbs66626252orb_s
ores46056682_ores
orles55326212orles
oses46641512_oses
owes75137102_owes
oxes116530722_oxes
oyes74940132_oyes
pokes116133012pokes
poles75351002poles
pomes94833932pomes
pones74547042pones
popes95933812popes
pores75849032pores
poses74642762poses
poxes145325722poxes
probe94320812probe_
probed114114822probed
prober104516072prober
probers113514572probers
proles84627202proles
proses84733472proses
proves114322252proves
pubes94423402pubes
rabies85226022rabies
races74943242races
rages64539442rages
rajes125022782rajes
rakes94440352rakes
rales54947492rales
rapes75740722rapes
rares55247442rares
rases55447212rases
rates55352012rates
raves85441972raves
raxes124729392raxes
razes145032702razes
rebbes10313532rebbes
rebec94416542rebec
rebecs103913672rebecs
rebel73421292rebel
rebels84518132rebels
rebs65733562reb_s
rebus75721112rebus
redes65139122redes
rees45364192r_ees
reges65628782reges
res35565042r__es
rexes124526952rexes
ribs65833022rib_s
rices75536152rices
rides66140812rides
riles55343642riles
rimes75634542rimes
ripes75435772ripes
rises55244042rises
rites54442552rites
rives85336002rives
roads66523612roads
roams74919612roams
roans54926442roans
roars55622232roars
rob56754302rob__
robbed113415192robbed
robber103916532robber
robbers112814152robbers
robin74820282robin
robins83617452robins
roble75223022roble
robot7325972robot
robots8313142robots
robust8310432robust
rocks114626412rocks
rocs65533662ro_cs
rode55844302rode_
rodeo65921092rodeo
rodeos75314502rodeos
rods56442062ro_ds
roe36861072ro_e_
roger64521412roger
rogers74517912rogers
rogues74617672rogues
roils54826792roils
role45851822role_
rolfs84817122rolfs
rolls55326232rolls
romeo73719702romeo
romeos84013172romeos
romps94617542romps
roms67038962ro_ms
roods65125282roods
roofs85321152roofs
rooks95325042rooks
rooms75324682rooms
roose56127092roose
rooses65526232rooses
roots55933672roots
rope65542912rope_
roped84630802roped
roper75431912roper
ropers84325902ropers
ropey106021872ropey
roques154912562roques
rose46148902rose_
rosed65930342rosed
roset55945242roset
rosets65819952rosets
rotas54827722rotas
rote46249022rote_
rotis56327052rotis
rotls55620162rotls
rotos56027882rotos
rots46454092ro_ts
rottes64524832rottes
roubles93413502roubles
roue45941742roue_
rouen54920902rouen
rouens64814442rouens
rouges76022382rouges
roups75118902roups
rouse56634702rouse
rouses65436282rouses
routes66129312routes
routs57133412routs
rove75136982rove_
roved95323552roved
roven85521972roven
rover85527372rover
rovers95423522rovers
rowed94034322rowed
rowel84721412rowel
rowels94515452rowels
rowen84921152rowen
rowens94515302rowens
rower85430492rower
rowers94924572rowers
rows75941752ro_ws
rube65532012rube_
rubel75416832rubel
rubels84112992rubels
rubies84420342rubies
rubles83921702rubles
rubs66133492rub_s
rubus76415052rubus
rues46044482r_ues
rules55234252rules
runes55530222runes
ruses56136582ruses
ryes75529352r_yes
rykes125513032rykes
sabes76437462sabes
sobas74424252sobas
sober74822402sober
sobers85218852sobers
sobs64941752sob_s
sokes95031422sokes
soles55547922soles
sones55444142sones
sores55454282sores
strobes93813262strobes
tabes76033922tabes
tobies84521022tobies
toes46956442to_es
tokes95234972tokes
toles55147132toles
tomes76037382tomes
tones56048662tones
topes76941762topes
tores55352672tores
totes55139682totes
tribes85119022tribes
trokes104019262trokes
trones65629282trones
tropes84824352tropes
troves94719112troves
tubes74826452tubes
unrobes9269732unrobes
vibes104719952vibes
voces105918052voces
voes75432822vo_es
voles86234042voles
votes84627082votes
woes76440662wo_es
yobs96028082yob_s
yokes125223022yokes
yores85031322yores
yowes114926372yowes
zones145528042zones

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.0931921408.6
2DLD Change Limit538003441.81329674.6
3Display Results3443440.0933698.9
 (SQL Overall)1786913441.99989390.2
 
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.