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

394 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
ropes7594006(None) 
copes97747101copes
dopes84935041dopes
gropes95220401gropes
hopes105835641hopes
lopes76437341lopes
mopes95134981mopes
opes65942611_opes
popes95933811popes
rapes75740721rapes
ripes75435771ripes
robes75133301robes
rodes614039081rodes
roes45954131ro_es
roles56747981roles
rope65542911rope_
roped84630801roped
roper75431911roper
ropers84325901ropers
ropey106021871ropey
roses56445771roses
rotes56143901rotes
roues56039351roues
roves84834481roves
topes76941761topes
tropes84824351tropes
apes66047432_apes
bodes84935102bodes
boles75448602boles
bones76446532bones
bops86037982bop_s
bores76448252bores
boxes145625072boxes
bromes104719762bromes
broses86524402broses
capes95441922capes
cepes94424462cepes
codes86247292codes
cokes115537192cokes
coles76055062coles
comes97246992comes
cones76457422cones
cope86847382cope_
coped105036842coped
copen94826432copen
copens106119962copens
coper95336092coper
copers104629842copers
copies104130302copies
cops86751372cop_s
copse95623922copse
copses104922472copses
cores76361852cores
coses76949492coses
cotes76347842cotes
coupes105022522coupes
coves105539172coves
coxes145430862coxes
cozes166033242cozes
crapes104727692crapes
crepes105419342crepes
cripes105120872cripes
crones84729242crones
crops96125232crop_s
crores86121162crores
croupes114613102croupes
crozes174417662crozes
does56554472do_es
doges75630162doges
doles67843752doles
domes85735562domes
dopas85019062dopas
dope76038892dope_
doped95326712doped
doper86128392doper
dopers95522482dopers
dopey116020352dopey
doses65938502doses
dotes65836692dotes
doves94728152doves
dozes155226302dozes
drapes95419652drapes
drones75023432drones
drops85719502drop_s
droves105116672droves
drupes94912652drupes
dupes86425932dupes
elopes85918162elopes
erodes74819882erodes
eroses65327052eroses
foes76543442fo_es
fops96532682fop_s
fores85847102fores
foxes156321092foxes
froes86126692fro_es
gapes86030822gapes
goes55644092go_es
gores65740372gores
goxes135018262goxes
grapes95123122grapes
gripes94619872gripes
grope84821612grope_
groped107515052groped
groper94517252groper
gropers104813852gropers
groves104318102groves
hoes75755732ho_es
hokes126231642hokes
holes84748652holes
homes106938812homes
hones88144492hones
hope96639672hope_
hoped115628182hoped
hoper105829142hoper
hopers114222972hopers
hops97942632hop_s
hoses85443172hoses
howes114730262howes
hypes135818672hypes
irones64724012irones
japes146322822japes
joes116635892jo_es
jokes165423332jokes
joles125230832joles
jones125028182jones
jupes145218552jupes
kopek1037812kopek
kopeks1134602kopeks
kophs145010932kophs
kopjes1935362kopjes
kops107031292kop_s
lobes75331002lobes
lodes66436912lodes
loges66534202loges
lope65941922lope_
loped85128332loped
loper75129232loper
lopers84424142lopers
lops66043352lop_s
lores55045402lores
loses56742012loses
loupes84918052loupes
loves85332012loves
lowes85732462lowes
loxes125227472loxes
modes85537412modes
mokes114631032mokes
moles74747922moles
momes95134472momes
mope86838042mope_
moped105424732moped
mopeds11499662mopeds
moper94925922moper
mopers104220372mopers
mopey124821822mopey
mops85940132mop_s
mores76249642mores
motes75944002motes
moues75732842moues
moves106128422moves
myopes13419962myopes
napes74828462napes
nodes64633492nodes
noes45845392no_es
nomes74933122nomes
nones55639132nones
nope65934192nope_
noses55435642noses
notes55034582notes
obes66036832_obes
odes57243242_odes
oes35866192_o_es
okes84936342_okes
oles46453472_oles
ones46146532_ones
oops65232672oop_s
oozes145418712oozes
ope56845242_ope_
oped76230152_oped
open66427002_open
opens76118552_opens
ops56641252_op_s
opts68124742_opts
opus66420592_opus
ores46056682_ores
orles55326212orles
oses46641512_oses
owes75137102_owes
oxes116530722_oxes
oyes74940132_oyes
pes57259782__pes
pipes96030142pipes
pokes116133012pokes
poles75351002poles
pomes94833932pomes
pones74547042pones
pope85535612pope_
pops86340952pop_s
pores75849032pores
poses74642762poses
poxes145325722poxes
probes104119452probes
proles84627202proles
propel103714062propel
propels113412842propels
proper104319952proper
propers113619032propers
props95726882prop_s
proses84733472proses
proves114322252proves
pyropes142210192pyropes
qophs19507812qophs
races74943242races
rages64539442rages
rajes125022782rajes
rakes94440352rakes
rales54947492rales
rape65041632rape_
raped85334622raped
raper74932752raper
rapers84327182rapers
raphes115117452raphes
raps66247732rap_s
rares55247442rares
rases55447212rases
rates55352012rates
raves85441972raves
raxes124729392raxes
razes145032702razes
redes65139122redes
rees45364192r_ees
reges65628782reges
reopen8311572reopen
reopens939372reopens
repeg84015052repeg
repegs93311942repegs
repel74921402repel
repels84318762repels
repos74725792repos
repps95114342repps
reps65937952rep_s
res35565042r__es
rexes124526952rexes
ribes75530172ribes
rices75536152rices
rides66140812rides
riles55343642riles
rimes75634542rimes
ripe66038922ripe_
riped85226432riped
ripen75619262ripen
ripens85012172ripens
riper74328402riper
ripest84317932ripest
rips66237432rip_s
rises55244042rises
rites54442552rites
rives85336002rives
roads66523612roads
roams74919612roams
roans54926442roans
roars55622232roars
robe65335642robe_
robed85323732robed
robles85321692robles
robs65837872ro_bs
rocks114626412rocks
rocs65533662ro_cs
rode55844302rode_
rodeo65921092rodeo
rodeos75314502rodeos
rods56442062ro_ds
roe36861072ro_e_
roger64521412roger
rogers74517912rogers
rogues74617672rogues
roils54826792roils
role45851822role_
rolfs84817122rolfs
rolls55326232rolls
romeo73719702romeo
romeos84013172romeos
romped114513652romped
romper104213682romper
rompers113412242rompers
romps94617542romps
roms67038962ro_ms
roods65125282roods
roofs85321152roofs
rooks95325042rooks
rooms75324682rooms
roose56127092roose
rooses65526232rooses
roots55933672roots
ropery114313872ropery
ropier84118802ropier
ropiest93317772ropiest
ropy96323412rop_y
roques154912562roques
rose46148902rose_
rosed65930342rosed
roset55945242roset
rosets65819952rosets
rotas54827722rotas
rote46249022rote_
rotis56327052rotis
rotls55620162rotls
rotos56027882rotos
rots46454092ro_ts
rottes64524832rottes
roue45941742roue_
rouen54920902rouen
rouens64814442rouens
rouges76022382rouges
rouped95717352rouped
roupet84218342roupet
roups75118902roups
rouse56634702rouse
rouses65436282rouses
routes66129312routes
routs57133412routs
rove75136982rove_
roved95323552roved
roven85521972roven
rover85527372rover
rovers95423522rovers
rowed94034322rowed
rowel84721412rowel
rowels94515452rowels
rowen84921152rowen
rowens94515302rowens
rower85430492rower
rowers94924572rowers
rows75941752ro_ws
rubes74928412rubes
rues46044482r_ues
rules55234252rules
runes55530222runes
rupee7321282rupee
rupees8312572rupees
ruses56136582ruses
ryes75529352r_yes
rykes125513032rykes
scopes104719592scopes
sipes76036952sipes
slopes84820452slopes
sokes95031422sokes
soles55547922soles
sones55444142sones
sophs104916022sophs
sops65244562sop_s
sores55454282sores
stopes84525892stopes
supes75628302supes
tapes75838602tapes
toes46956442to_es
tokes95234972tokes
toles55147132toles
tomes76037382tomes
tones56048662tones
tope65946382tope_
toped85631312toped
topee76029952topee
topees85519702topees
toper75231022toper
topers85025322topers
tophes115218422tophes
tophs105220052tophs
topis76025832topis
topos75726392topos
tops66248122top_s
tores55352672tores
totes55139682totes
trapes85024462trapes
tripes85324872tripes
trokes104019262trokes
trompes114111622trompes
trones65629282trones
trope75725802trope_
troupes94112842troupes
troves94719112troves
types105721062types
voces105918052voces
voes75432822vo_es
voles86234042voles
votes84627082votes
wipes104827082wipes
woes76440662wo_es
wops96634152wop_s
yipes106017842yipes
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 Limit538003941.84329191.5
3Display Results3943940.1103581.8
 (SQL Overall)1786913942.04687336.8
 
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.