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

193 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
tagrags93612(None) 
tagrag837041tagrag_
jagras1438462jagra_s
ragbags1135112ragbags
ragtags935372ragtags
tangrams1136162tangrams
agars66120643_ag_ars
agas55938843_ag_a_s
aghas97014873_agha_s
agings86312673_agings
agmas85919873_agma_s
agoras7613343_agora_s
agrafe1038093_agrafe
agrafes1137523_agrafes
agrees74915323_agrees
agrias74315393_agrias
airbags1036293_airbags
anagrams1146593anagrams
araks94820883_a_raks
argals75517713_argals
arras55626133_arra_s
arrays95311683_arrays
ataghans1244263ataghans
auras55932563_aura_s
bagass938933bag_ass
baggage1235633baggage
baggages1335443baggages
bagwigs1432823bagwigs
barrage10710843barrage
barrages11711083barrages
brags85625103__brags
carats85929023ca_rats
crags85622573__crags
daggas937973dagga_s
defrags1236193defrags
diagrams1246133diagrams
drags75521113__drags
eagres74014573eagr_es
engrams1038073engrams
farads104713273fa_rads
farrago1144923farrago
frags96322173__frags
gags66441063__g_ags
garage8314513ga_rage
garages9314113ga_rages
gasbags1135473gasbags
grabs85719693__grabs
grads75625753__grads
grams85327313__grams
grans64832543__grans
grass66125203__grass
grays95621333__grays
grigs75318193__grigs
grogs76319413__grogs
hangtags1344163hangtags
harass9313943ha_rass
jaggs148111493jag__gs
jagra1338173jagra__
jaguars1535233jaguars
jarrahs1735453jarrahs
karats106420493ka_rats
lagans75717783lag_ans
langrage10106033langrage
langrages11105903langrages
lauras63414333laura_s
madras94316433madra_s
magians10310753magians
magmas115512503magma_s
maras75443293ma_ra_s
margays1337493margays
marrams11310123marrams
matrass939403matrass
nairas6312783naira_s
padnags1135083padnags
pagans95717923pag_ans
pagings114411063pagings
pangrams1337153pangrams
parangs104314373pa_rangs
paras76143043pa_ra_s
parrals94414573parrals
ragas65326063rag_a_s
ragbag1045463ragbag_
raggs75216473rag__gs
raglans82410133raglans
rags55448373___rags
ragtag836643ragtag_
ratbags1035763ratbags
raygrass1242883raygrass
sabras85116363sabra_s
sacrals93311793sacrals
sagas66025883sag_a_s
saggars93610683saggars
sarans64224433sa_rans
satraps95011643satraps
scrags95713803_scrags
sprags95715823_sprags
stagings10378343stagings
stalags838643sta_lags
tabards10310383tabards
tablas83716163tabla_s
tafias93111963tafia_s
taggant9310223taggant
taggants1044933taggants
taggers93514193taggers
tags55545243t___ags
tahrs85412333tahr__s
taigas73712573taiga_s
taipans9269553taipans
takas95520683ta_ka_s
takings124512573takings
talars66021683ta_lars
talas55935893ta_la_s
tallage82712073tallage
tallages92312003tallages
tallgrass1042833tallgrass
tamals84116633ta_mals
tamaraos10105883tamaraos
tamaraus1096183tamaraus
tamaris9413603tamaris
tambacs13219363tambacs
tambaks15218153tambaks
tampans113310983tampans
tangram1038083tangra_m
tangs65028363ta__ngs
tankage12257773tankage
tankages13217113tankages
tankas104613773tanka_s
tannage8209583tannage
tannages9228963tannages
tanrecs934823tanrecs
tantras73112093tantra_s
tapas74627713ta_pa_s
tarama8412733ta_rama
taramas9612703ta_ramas
tares57456563ta_r_es
targe65227103ta_r_ge
targes74524603ta_rges
targets84314223targets
tarmacs1138323tarmacs
tarns56433953ta_r_ns
tarocs84615663ta_rocs
taroks106115283ta_roks
taros55640823ta_r_os
tarots66422993ta_rots
tarpans92513533tarpans
tarps76527123ta_r_ps
tarragon944673tarragon
tarragons1044483tarragons
tarres64723043ta_rres
tarries73324263tarries
tars46763953ta_r__s
tarsals72512603tarsals
tarsus6310513ta_rsus
tartans72615823tartans
tartars73313403tartars
tarts57242023ta_r_ts
tarzans16329923tarzans
tatars64619793ta_tars
tautaugs9162483tautaugs
tautogs875413tautogs
tazzas1436283tazza_s
teargas837013tearga_s
teggs74710743teg__gs
teguas768013tegua_s
terais64023513t_erais
terras63516973terra_s
tetrads82910193tetrads
tetras63017623tetra_s
thirams1236823thirams
thraws129211103t_hraws
tiaras6314553tiara_s
tigress836093tigress
togas67823003tog_a_s
torahs95115643t_orahs
toras55540373t_ora_s
tragi64717173t__ragi
tragus749233t__ragus
trams75327673t__rams
trans54933043t__rans
traps75727483t__raps
trass56226473t__rass
trays85623433t__rays
trigrams11116353trigrams
trigs65423063t__rigs
trogs67022603t__rogs
trugs65516803t__rugs
tugriks1233153tugriks
vagrant11410663vagrant
vagrants1246143vagrants
varas86028193va_ra_s
washrags1543893washrags
wigwags1543293wigwags
zigzags1742273zigzags

Search took 10 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.403443402.0
2DLD Change Limit1340271938.50315762.3
3Display Results1931930.0603216.7
 (SQL Overall)1786911938.96619929.8
 
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.