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

237 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
ragtag83664(None) 
ragbag1045461ragbag
ragtags935371ragtags
hangtag1244532hangtag
raga55930812rag_a_
ragas65326062rag_as
ragbags1135112ragbags
ragg65622692rag__g
raging85126432raging
raglan73711502raglan
ragman94013712ragman
ragtop936682ragtop
raita54623072raita_
raitas64417672raitas
ratal55025112ra_tal
ratan53722662ra_tan
ratbag956562ratbag
rattan63613602rattan
retag63618412r_etag
tagrag837042tagrag
acta69524803_acta_
aga410447233_ag_a_
agar58726413_ag_ar
agas55938843_ag_as
agate66525153_agate
agha87417303_agha_
aghas97014873_aghas
aging77026353_aging
agita6315423_agita_
agitas7310593_agitas
agma77623263_agma_
agmas85919873_agmas
agog68019003_ag_og
altar55520643_altar
anta46839583_anta_
antae56828293_antae
antas55432033_antas
argal65023393arg_al
artal55525473_artal
atap66722453_a_tap
attar56516693_attar
baggage1235633baggage
bagman114613813bagman
bagwig1343083bagwig
bantam10314063bantam
caftan111710123caftan
caging105321023caging
cantal84122033cantal
captan101613343captan
cartage10312593cartage
dagga839543dagga_
daggas937973daggas
data56026653da_ta_
fatal84819373fa_tal
fractal1237623fractal
gag57753633__g_ag
gaga66625553gag_a_
gaging94718403gaging
gagman103811243gagman
gasbag1035413gasbag
graftage1343683graftage
graylag1283113graylag
hangtags1344163hangtags
hartal9415473hartal
jagg136115313jag__g
jagra1338173jagra_
jagras1438463jagras
jaguar1435283jaguar
kaftan13185823kaftan
kantar10311153kantar
kata85626023ka_ta_
katas95922093ka_tas
lactam10310943lactam
lagan66520343lag_an
magian9312833magian
magma104513573magma_
magmas115512503magmas
manta75629913manta_
mantas85725363mantas
nametag1044443nametag
natal53921493na_tal
padnag1036073padnag
pagan86121163pag_an
paging104020403paging
partan83820563partan
pasta76624533pasta_
pastas85422873pastas
rabat72832223ra_bat
rabato83413263rabato
rabats83116223rabats
racial83419243racial
racing95030533racing
radar61316723ra_dar
radial74020393radial
radian74117273radian
raft76245913raft__
rafted104714703rafted
rafter94517583rafter
rafting113815753rafting
rafts87820633raft_s
rag45761323r___ag
rage55742353rag__e
raged74829453rag_ed
ragee65432663rag_ee
ragees74618663ragees
rages64539443rag_es
ragged94620263ragged
raggee84217603raggee
ragging103516683ragging
raggle83712883raggle
raggs75216473rag_gs
raggy106116573rag_gy
ragi56032283rag__i
ragis66325603rag_is
raglans82410133raglans
ragmen93712183ragmen
ragout7317183ragout
rags55448373rag__s
ragtime1036163ragtime
ragtops1035453ragtops
raia46638383ra_ia_
raias54631123ra_ias
raja117918683ra_ja_
rajah155711423ra_jah
rajas127317723ra_jas
raking114728423raking
ramal74622243ra_mal
ramate83921683ramate
rampage1237453rampage
ramtil8311023ramtil
randan7315253randan
rang56939163ra__ng
ranging94120263ranging
rant45864683rant__
ranted74324703ranted
ranter63826823ranter
ranting84025413ranting
rants55935343rant_s
raphae114311733raphae
raping94829853raping
rapt67245313rapt__
raptly11338913raptly
raptor83912823raptor
raring74332873raring
rascal8511123rascal
rasing74330833rasing
raster64731443raster
rat37892743ra_t__
ratals64219583ra_tals
ratans63819373ra_tans
ratany93411873ra_tany
ratatat7412263ratatat
ratbags1035763ratbags
ratch104221363ra_tch
rate45458763ra_t_e
rated65441383ra_ted
ratel54224883ra_tel
rater54943283ra_ter
rates55352013ra_tes
rath76037663ra_t_h
rathe85821923ra_the
rating74938703rating
ratio55227583ra_tio
rato45436973ra_t_o
ratos55528763ra_tos
rats46260373ra_t_s
rattail737803rattail
rattans73411953rattans
ratted74923343ratted
ratten64217383ratten
ratter64326313ratter
ratting83822363ratting
rattle64717613rattle
rattly94111543rattly
ratton64116123ratton
rattrap945263rattrap
ratty84819593ra_tty
ravage1039303ra_vage
raving105128853raving
raxing144321023raxing
raya75224823ra_ya_
rayah116013503ra_yah
rayas85922053ra_yas
raying105027193raying
razing164524543razing
reata54225393reata_
reatas64021013reatas
recta74220263recta_
rectal84418133rectal
reflag1098083reflag
regal65023793reg_al
regear73512743regear
reggae858953reggae
regma84612333regma_
regna64614813regna_
regnal74812933regnal
rental63922023rental
restage83316193restage
retags73414303r_etags
retax124517973r_etax
rhyta1135083rhyta_
riata54618023riata_
riatas63915093riatas
rictal83113183rictal
ringtaw1154363ringtaw
rootage839053rootage
rota45834343r_ota_
rotas54827723r_otas
ruga56121233rug_a_
rugae65114763rug_ae
rugal65916093rug_al
rugate75813813rugate
saga55331173sag_a_
sagas66025883sag_as
saggar84010853saggar
satang75711563sa_tang
satay84718463sa_tay
stag57332003__stag
tag47259493___tag
tagrags936123tagrags
tartan64217513tartan
tartar63214753tartar
tatar56122063ta_tar
tautaug883023tautaug
tautog765713tautog
vagal94613633vag_al
vantage11109893vantage
waftage14115323waftage
waging114318383waging
wagtail1145043wagtail
wantage11119623wantage
wastage11109253wastage
watap102111673wa_tap
wattage1186983wattage
wigwag1443723wigwag
zaftig1933253zaftig
zigzag1642963zigzag

Search took 6 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.373479064.3
2DLD Change Limit1127162375.51620434.4
3Display Results2372370.0802962.5
 (SQL Overall)1786912375.96929936.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  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.