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

168 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
ragtags93537(None) 
ragbags1135111ragbags
ragtag836641ragtag_
hangtags1344162hangtags
ragas65326062rag_a_s
ragbag1045462ragbag_
raggs75216472rag__gs
raglans82410132raglans
ragtops1035452ragtops
raitas64417672raita_s
ratals64219582ra_tals
ratans63819372ra_tans
ratbags1035762ratbags
rattans73411952rattans
retags73414302r_etags
tagrags936122tagrags
agars66120643_ag_ars
agas55938843_ag_a_s
agates76121343_agates
aghas97014873_agha_s
agings86312673_agings
agitas7310593_agita_s
agmas85919873_agma_s
altars64518153_altars
antas55432033_anta_s
argals75517713arg_als
ataps76414833_a_taps
attars64515313_attars
bagass938933bag_ass
baggage1235633baggage
baggages1335443baggages
bagwigs1432823bagwigs
bantams1149063bantams
caftans12179443caftans
cantals93919573cantals
captans111612053captans
cartage10312593cartage
cartages11313313cartages
daggas937973dagga_s
fractals1346133fractals
gags66441063__g_ags
gasbags1135473gasbags
graftage1343683graftage
graftages1443683graftages
graylags1372983graylags
hangtag1244533hangtag_
hartals10313023hartals
jaggs148111493jag__gs
jagras1438463jagra_s
jaguars1535233jaguars
kaftans14185353kaftans
kantars11310033kantars
katas95922093ka_ta_s
lactams1136953lactams
lagans75717783lag_ans
magians10310753magians
magmas115512503magma_s
mantas85725363manta_s
nametags1143093nametags
padnags1135083padnags
pagans95717923pag_ans
pagings114411063pagings
partans94418283partans
pastas85422873pasta_s
rabatos93010903rabatos
rabats83116223ra_bats
racings105015133racings
radars71314673ra_dars
radials83614643radials
radians83013823radians
rafters103715633rafters
rafts87820633raft__s
raga55930813rag_a__
ragees74618663rag_ees
rages64539443rag__es
ragg65622693rag__g_
raggees93710913raggees
raggies93214733raggies
raggles93813283raggles
raggy106116573rag__gy
raging85126433raging_
ragis66325603rag__is
raglan73711503ragla_n
ragman94013713ragma_n
ragouts838543ragouts
rags55448373r___ags
ragtime1036163ragtime
ragtimes1135823ragtimes
ragtop936683ragt_op
raias54631123ra_ia_s
raita54623073raita__
rajahs16497663ra_jahs
rajas127317723ra_ja_s
rampage1237453rampage
rampages1336673rampages
ramtils938413ramtils
randans8313213randans
ranters73323643ranters
rants55935343rant__s
raptors94213353raptors
rascals959663rascals
rasters74629023rasters
ratal55025113ra_ta_l
ratan53722663ra_ta_n
ratany93411873ra_tany
ratatats846063ratatats
ratbag956563ratbag_
ratels64518213ra_tels
raters63936583ra_ters
rates55352013ra_t_es
ratings84217413ratings
ratios64922673ra_tios
ratos55528763ra_t_os
rats46260373ra_t__s
rattail737803rattail
rattails837133rattails
rattan63613603ratta_n
rattens74213403rattens
ratters74422473ratters
rattles73217303rattles
rattons73815323rattons
rattraps1044823rattraps
ravage1039303ra_vage
ravages1139403ra_vages
ravings114614503ravings
rayahs12579193ra_yahs
rayas85922053ra_ya_s
raygrass1242883raygrass
reatas64021013reata_s
reflags1156953reflags
regears83012463regears
reggaes948883reggaes
rentals74017473rentals
restage83316193restage
restages92815773restages
retag63618413r_etag_
riatas63915093riata_s
ringtaws1243563ringtaws
rootage839053rootage
rootages939103rootages
rotas54827723r_ota_s
sagas66025883sag_a_s
saggars93610683saggars
satangs8479713sa_tangs
satays94411683sa_tays
stags66226743__stags
tagrag837043tagrag_
tags55545233___tags
tartans72615823tartans
tartars73313403tartars
tatars64619793ta_tars
tautaugs9162483tautaugs
tautogs875413tautogs
vantage11109893vantage
vantages12119023vantages
waftage14115323waftage
waftages15105393waftages
wagtail1145043wagtail
wagtails1244443wagtails
wantage11119623wantage
wantages12109023wantages
wastage11109253wastage
wastages12109753wastages
wataps11248683wa_taps
wattage1186983wattage
wattages12106783wattages
wigwags1543293wigwags
zigzags1742273zigzags

Search took 7 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 Filter1786911340270.390458182.1
2DLD Change Limit1340271686.47020715.1
3Display Results1681680.0632666.7
 (SQL Overall)1786911686.92325811.2
 
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.