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

400 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
topes7694176(None) 
copes97747101copes
dopes84935041dopes
hopes105835641hopes
lopes76437341lopes
mopes95134981mopes
opes65942611_opes
popes95933811popes
ropes75940061ropes
stopes84525891stopes
tapes75838601tapes
toes46956441to_es
tokes95234971tokes
toles55147131toles
tomes76037381tomes
tones56048661tones
tope65946381tope_
toped85631311toped
topee76029951topee
topees85519701topees
toper75231021toper
topers85025321topers
tophes115218421tophes
tophs105220051tophs
topis76025831topis
topos75726391topos
tops66248121top_s
tores55352671tores
totes55139681totes
tropes84824351tropes
types105721061types
apes66047432_apes
atones65225772atones
atopies92816432atopies
bodes84935102bodes
boles75448602boles
bones76446532bones
bops86037982bop_s
bores76448252bores
boxes145625072boxes
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
does56554472do_es
doges75630162doges
doles67843752doles
domes85735562domes
dopas85019062dopas
dope76038892dope_
doped95326712doped
doper86128392doper
dopers95522482dopers
dopey116020352dopey
doses65938502doses
dotes65836692dotes
doves94728152doves
dozes155226302dozes
dupes86425932dupes
elopes85918162elopes
etapes85415292etapes
foes76543442fo_es
fops96532682fop_s
fores85847102fores
foxes156321092foxes
gapes86030822gapes
goes55644092go_es
gores65740372gores
goxes135018262goxes
gropes95220402gropes
hoes75755732ho_es
hokes126231642hokes
holes84748652holes
homes106938812homes
hones88144492hones
hope96639672hope_
hoped115628182hoped
hoper105829142hoper
hopers114222972hopers
hops97942632hop_s
hoses85443172hoses
howes114730262howes
hypes135818672hypes
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
metopes11311362metopes
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
oses46641512_oses
owes75137102_owes
oxes116530722_oxes
oyes74940132_oyes
pes57259782__pes
pipes96030142pipes
pokes116133012pokes
poles75351002poles
pomes94833932pomes
pones74547042pones
pope85535612pope_
pops86340952pop_s
pores75849032pores
poses74642762poses
poxes145325722poxes
ptoses83514672ptoses
qophs19507812qophs
rapes75740722rapes
ripes75435772ripes
robes75133302robes
rodes614039082rodes
roes45954132ro_es
roles56747982roles
rope65542912rope_
roped84630802roped
roper75431912roper
ropers84325902ropers
ropey106021872ropey
roses56445772roses
rotes56143902rotes
roues56039352roues
roves84834482roves
scopes104719592scopes
sipes76036952sipes
slopes84820452slopes
sokes95031422sokes
soles55547922soles
sones55444142sones
sophs104916022sophs
sops65244562sop_s
sores55454282sores
stapes85028732stapes
stipes84524052stipes
stokes104821792stokes
stoles63927672stoles
stones65130032stones
stope74727242stope_
stoped94721012stoped
stoper84320092stoper
stopers94217362stopers
stops74827282stop_s
stores65533642stores
stoves93818922stoves
stupes84116952stupes
supes75628302supes
tabes76033922tabes
taces76237802taces
tajes124920692tajes
takes94437792takes
tales55451372tales
tames75242012tames
tapas74627712tapas
tape64538142tape_
taped85327422taped
taper74829772taper
tapers84025812tapers
tapis75028862tapis
taps66050672tap_s
tares57456562tares
tates55444982tates
taupes8212672taupes
taxes124730822taxes
tees45353582t_ees
teles54536002teles
tepas76521682tepas
tepee74724212tepee
tepees84215242tepees
tholes94919782tholes
thorpes125010352thorpes
tides64830152tides
ties45248312t_ies
tikes95628902tikes
tiles55542102tiles
times75630822times
tines54848422tines
tipis76019922tipis
tips66436762tip_s
tires55437492tires
toads65621062toads
tobies84521012tobies
todies74223552todies
tods56141842to_ds
toe310166852to_e_
toea46732332to_ea
toeas55726422toeas
toed56137042to_ed
toffs116016722toffs
tofts84919242tofts
tofus86415422tofus
togas67823002togas
togs57242432to_gs
togues76014242togues
toiles63923512toiles
toils54527492toils
toits55327472toits
toke86738492toke_
toked105626492toked
token95419312token
tokens104711562tokens
toker95924912toker
tokers104818892tokers
tolas54532772tolas
tole46052902tole_
toled65934922toled
tolls54728432tolls
tolus55024482tolus
tombs97818732tombs
tome67543192tome_
toms68343492to_ms
tone46953742tone_
toned65435342toned
toner55336242toner
toners64128002toners
toney86027412toney
tongs65928462tongs
tonnes65320852tonnes
tons46553052to_ns
tonus56324302tonus
tools55325242tools
toons55027532toons
toots55331872toots
top510560682top__
topaz16315322topaz
topazes1857312topazes
toph96326872top_h
tophe106718972tophe
tophi105215302tophi
tophus115210362tophus
topi67830392top_i
topic95721502topic
topics104714582topics
topless92511122topless
topo66932402top_o
topoi76018352topoi
topped114617722topped
topper103817602topper
toppers113914602toppers
topples113111652topples
toques154612352toques
toras55540372toras
torcs75123762torcs
tore47359322tore_
tories65435882tories
toros54336192toros
torrs53923562torrs
tors46157382to_rs
torse55833332torse
torses64727952torses
tortes64826052tortes
torts56138122torts
torus54329762torus
toshes94520102toshes
toss45637972to_ss
tosses65225392tosses
tote46643672tote_
toted64929482toted
totem74819362totem
totems86810762totems
toter55932132toter
toters65026362toters
tots46654122to_ts
toupee8316132toupee
toupees938512toupees
tours55325862tours
touse55430672touse
touses64229672touses
touts54830392touts
towed95134582towed
towel84920522towel
towels94314642towels
tower85729202tower
towers94423672towers
towies93521192towies
towns86018882towns
tows78545552to_ws
toyed96019802toyed
toyer84521552toyer
toyers95516332toyers
toyos87519142toyos
toys78036342to_ys
trapes85024462trapes
trees55835762trees
tres46542902t_res
tries55742812tries
tripes85324872tripes
trokes104019262trokes
trompes114111622trompes
trones65629282trones
trope75725802trope_
troupes94112842troupes
troves94719112troves
trues54925322trues
tsores65113662tsores
tubes74826452tubes
tules54532792tules
tunes55332192tunes
tups65628762tup_s
tuxes124316042tuxes
twaes86513662twaes
tyees86019452tyees
tyes76433372t_yes
tykes125817062tykes
tynes85920302tynes
type96223742type_
typed115815452typed
typey135511882typey
typos106015812typos
typps12549302typps
tyres84725232tyres
voces105918052voces
voes75432822vo_es
voles86234042voles
votes84627082votes
wipes104827082wipes
woes76440662wo_es
wops96634152wop_s
yipes106017842yipes
yokes125223022yokes
yores85031322yores
yowes114926372yowes
zones145528042zones

Search took 2 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 Limit538004001.70331591.3
3Display Results4004000.1103636.4
 (SQL Overall)1786914001.90693751.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.