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

223 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
ragtop93668(None) 
ragtops1035451ragtops
atop66124752_a_top
cartop104213562cartop
laptop1076812laptop
ragtag836642ragtag
raptor83912822raptor
rato45436972ra_to_
ratos55528762ra_tos
ratton64116122ratton
redtop937972redtop
actor71116073_actor
agio57828453_agio_
agios65919863_agios
aglow94711963_aglow
ago48845523_ag_o_
agog68019003_ag_og
agon56531883_ag_on
alto47831263_alto_
altos55822953_altos
argol65317263arg_ol
argon65520593arg_on
argot67728643arg_ot
argots74116023argots
atap66722453_a_tap
atom67824523_a_tom
atopy106813393_a_topy
auto47432083_auto_
autos56523323_autos
barhop13319643barhop
baton75822423ba_ton
caltrop11267633caltrop
canto74931013canto_
canton85722993canton
cantor85621523cantor
cantos84826973cantos
captor104914603captor
carhop133610763carhop
carton84522663carton
castor84418533castor
craton84517193cra_ton
dago65725083dag_o_
dagos76419443dag_os
dalton7311273dalton
dato56129943da_to_
datos65222783da_tos
datto65416423datto_
dattos74311903dattos
dragon838843drag_on
dragoon935283dragoon
dragrope1243203dragrope
estop74312103_estop
factor11911453factor
faggot1139043faggot
fagot9323403fag_ot
fagots1039963fagots
fantod102010033fantod
fantom112110803fantom
flattop1244403flattop
gallop93311383gallop
galop84716213ga_lop
gator64416033ga_tor
glop76724633__glop
goop75829483__goop
grantor84010933grantor
hagdon1188283hagdon
hardtop1345053hardtop
hightop1645013hightop
jalop144212603ja_lop
jato115822683ja_to_
jatos125116823ja_tos
lagoon7410483lagoon
laptops1166603laptops
madtom1138023madtom
maggot10311703maggot
magilp1137613magilp
magot8326393mag_ot
magots9312363magots
maintop1135143maintop
maltol8310843maltol
maypop1565143maypop
netop7312343_netop
orator6314533ora_tor
pagod95013683pag_od
palmtop1343873palmtop
panto76129413panto_
pantos85222743pantos
parton84720993parton
pastor84817483pastor
postop10511943postop
praetor938973praetor
rabato83413263rabato_
rabatos93010893rabatos
racon75422143ra_con
racoon83814473racoon
radio64922493radio_
radios74018673radios
radon64620503ra_don
raft76245913raft__
rafted104714703rafted
rafter94517583rafter
rafts87820633raft_s
rag45761323rag___
raga55930813rag__a
ragas65326063rag_as
ragbag1045463ragbag
rage55742353rag__e
raged74829453rag_ed
ragee65432663rag_ee
ragees74618663ragees
rages64539443rag_es
ragg65622693rag__g
ragged94620263ragged
raggee84217603raggee
raggle83712883raggle
raggs75216473rag_gs
raggy106116573rag_gy
ragi56032283rag__i
raging85126433raging
ragis66325603rag_is
raglan73711503raglan
ragman94013713ragman
ragmen93712183ragmen
ragout7317183ragout
rags55448373rag__s
ragtags935373ragtags
ragtime1036163ragtime
ragwort11510733ragwort
raita54623073rait_a
raitas64417673raitas
ramp85934003ra__mp
ramrod936833ramrod
ramson8310463ramson
ramtil8311023ramtil
rancor8810373rancor
random92513553random
ransom82410943ransom
rant45864673rant__
ranted74324703ranted
ranter63826823ranter
rants55935343rant_s
rap56261963ra___p
rapt67245313rapt__
raptly11338913raptly
raptors94213353raptors
rasp66029163ra__sp
raster64731443raster
rat37892743ra_t__
ratal55025113ra_tal
ratan53722663ra_tan
ratch104221363ra_tch
rate45458763ra_t_e
rated65441383ra_ted
ratel54224883ra_tel
rater54943283ra_ter
rates55352013ra_tes
rath76037663ra_t_h
rathe85821923ra_the
ratio55227583ra_tio
ration64226013ration
ratios64922673ratios
ratoon64417373ratoon
rats46260373ra_t_s
rattan63613603rattan
ratted74923343ratted
ratten64217383ratten
ratter64326313ratter
rattle64717613rattle
rattly94111543rattly
rattons73815323rattons
rattoon7359243rattoon
rattrap945263rattrap
ratty84819593ra_tty
rayon83815703ra_yon
razor143012603ra_zor
reactor93011653reactor
realtor73611353realtor
rebop9313283r_ebop
recto74520803recto_
rector84019743rector
rectos85718783rectos
redtops1037373redtops
region74614903region
reglow10339403reglow
regroup1095173regroup
regrow10309883regrow
rhetor938063rhetor
rhyton12356113rhyton
rialto638603rialto_
rialtos736613rialtos
ridgetop1242233ridgetop
righto104111093righto_
rigor62714053rig_or
ripstop1174763ripstop
rolltop944043rolltop
rooftop12133253rooftop
roto45935053r_oto_
rotor55519733r_otor
rotos56027883r_otos
sago56332673sag_o_
sagos66123873sag_os
saloop84212583saloop
sannop837373sannop
santo56227283santo_
santol64515243santol
santos64421833santos
sartor6313873sartor
stop66532033__stop
tanto55724943tanto_
tattoo6310973tattoo
tautog765713tautog
tiptop1036103tiptop
top510560683___top
tractor9311333tractor
traitor7310123traitor
treetop945523treetop
unstop837473unstop
vagrom1235943vagrom
waggon1136393waggon
wagon94312953wag_on
wallop113310293wallop
wanton94413813wanton
watap102111673wa_tap

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 Filter1786911127160.1401276364.3
2DLD Change Limit1127162238.51613235.8
3Display Results2232230.0802787.5
 (SQL Overall)1786912238.73620454.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.