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

190 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
rotos5602788(None) 
kotos95717691kotos
lotos54724631lotos
ratos55528761ratos
roots55933671roots
rotas54827721rotas
rotes56143901rotes
rotis56327051rotis
rotls55620161rotls
roto45935051roto_
rotor55519731rotor
rotors64917931rotors
rots46454091rot_s
altos55822952altos
autos56523322autos
bohos105618252bohos
bolos75531372bolos
boos67955032bo_os
boots75837972boots
botas75328782botas
bots66453952bot_s
botts75224862botts
boyos105418282boyos
bozos165216862bozos
bromos104213312bromos
broos75126412bro_os
broths115013922broths
cocos95624692cocos
cohos105921852cohos
contos84923232contos
coos67456492co_os
coots75636842coots
cotes76347842cotes
cots68054842cot_s
croton84415452croton
crotons93714372crotons
datos65222782datos
dodos75819392dodos
dojos135111792dojos
dotes65836692dotes
dots55647662dot_s
foots85528282foots
froths125411442froths
gobos86219372gobos
gogos77516522gogos
goos57644912go_os
goths96513002goths
grots65025852grot_s
grottos8337332grottos
hobos106321352hobos
homos105921782homos
hoots84830242hoots
hots78349322hot_s
iotas54821112iotas
irokos1037232irokos
jatos125116822jatos
jotas125717442jotas
jots116336142jot_s
kobos115616892kobos
kolos94921212kolos
koto86323462koto_
kotow12528702kotow
kotows13446512kotows
lobos75921842lobos
locos75822602locos
logos67225332logos
loos49051122lo_os
loots55431422loots
lotas55926302lotas
lots47652092lot_s
lottos64613102lottos
lotus55718062lotus
mojos145314462mojos
monos75930862monos
moos66051302mo_os
moots75831662moots
motes75944002motes
moths106021552moths
motor75317292motor
motors84616592motors
mots66853162mot_s
mottos84615242mottos
motts76527002motts
mozos165516332mozos
nolos54423352nolos
nomos75919742nomos
notes55034582notes
onos46229002_onos
oots46446442oot_s
ordos65216202ordos
orts46538332ort_s
orzos143311252orzos
ottos54714322ottos
photos113316632photos
polos76129912polos
pomos95321582pomos
poos65949112po_os
pothos114214692pothos
pots66452362pot_s
pottos84615872pottos
promos105116422promos
prosos85718552prosos
proton84318892proton
protons93118002protons
rates55352012rates
ratios64922672ratios
rato45436972rato_
rats46260372rat_s
rectos85718782rectos
redos65126762redos
repos74725792repos
retros63820192retros
rets45352562ret_s
rhos76319062r_hos
riotous739862riotous
riots54922012riot_s
rites54442552rites
roads66523612roads
roams74919612roams
roans54926442roans
roars55622232roars
robes75133302robes
robot7325972robot
robots8313142robots
robs65837872ro_bs
rocks114626412rocks
rocs65533662ro_cs
rodeos75314502rodeos
rodes614039082rodes
rods56442062ro_ds
roes45954132ro_es
roils54826792roils
roles56747982roles
rolfs84817122rolfs
rolls55326232rolls
romeos84013172romeos
romps94617542romps
roms67038962ro_ms
rondos74616722rondos
rood56733002ro_od
roods65125282roods
roof75738832ro_of
roofs85321152roofs
rook85532032ro_ok
rooks95325042rooks
room66235082ro_om
rooms75324682rooms
roose56127092ro_ose
roost55730932ro_ost
root45655922ro_ot
rooty86423022rooty
ropes75940062ropes
roses56445772roses
rot37282952rot__
rota45834342rot_a
rotch105815932rotch
rote46249022rot_e
roti46332922rot_i
rotl45029682rot_l
rotte54625932rotte
rottes64524832rottes
roues56039352roues
roups75118902roups
routes66129312routes
rouths95416822rouths
routs57133412routs
roves84834482roves
rows75941752ro_ws
rowths12458172rowths
ruths85714642ruths
ruts44541492rut_s
ryots85313782ryot_s
solos54830792solos
soots55536202soots
soths86218622soths
sotol54917642sotol
sotols63714452sotols
sots45552442sot_s
toots55331872toots
topos75726392topos
toros54336192toros
totes55139682totes
tots46654122tot_s
toyos87519142toyos
troths95414152troths
trots56629942trot_s
votes84627082votes
woos76238802wo_os
wots76342892wot_s
zoos135828802zo_os

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.0762351197.4
2DLD Change Limit538001902.22024234.2
3Display Results1901900.0633015.9
 (SQL Overall)1786911902.35975748.6
 
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.