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

260 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
tagrag83704(None) 
tagrags936121tagrags
jagra1338172jagra_
jagras1438462jagras
ragbag1045462ragbag
ragtag836642ragtag
tangram1038072tangram
aga410447233_ag_a_
agar58726413_ag_ar
agars66120643_agars
agas55938843_ag_as
agha87417303_agha_
aghas97014873_aghas
aging77026353_aging
agma77623263_agma_
agmas85919873_agmas
agog68019003_ag_og
agora6914333_agora_
agorae7511203_agorae
agoras7613343_agoras
agrafe1038093_agrafe
agree65226033_agree
agria65517143_agria
agrias74315393_agrias
airbag956963_airbag
anagram1058193anagram
arak86929573_a_rak
argal65023393_argal
arras55626133_arras
array86317143_array
ataghan1144653ataghan
aura45836253_aura_
aurae54128113_aurae
aural54428963_aural
aurar54420253_aurar
auras55932563_auras
baggage1235633baggage
bagman114613813bagman
bagwig1343083bagwig
barrage10710843barrage
brag75229723__brag
caging105321023caging
carat75048793ca_rat
crag75625303__crag
dagga839543dagga_
daggas937973daggas
defrag1136463defrag
diagram1147363diagram
drag64825053__drag
eagre64315323eagr_e
eagres74014573eagres
engram9310653engram
farad95720673fa_rad
farrago1144923farrago
frag85126273__frag
gag57753633__g_ag
gaga66625553gag_a_
gaging94718403gaging
gagman103811243gagman
garage8314513ga_rage
gasbag1035413gasbag
grab75427613__grab
grad66829863__grad
gram77034583__gram
gran56335013__gran
grat55651283__grat
gray85329893__gray
grig65424773__grig
grog65923343__grog
hangtag1244533hangtag
jagg136115313jag__g
jaguar1435283jaguar
jarrah1636683jarrah
karat96837593ka_rat
labra75415463labra_
lagan66520343lag_an
langrage10106033langrage
laura54116203laura_
laurae64011663laurae
lauras63414333lauras
madras94316433madras
magian9312833magian
magma104513573magma_
magmas115512503magmas
mara67444573ma_ra_
maras75443293ma_ras
margay12310593margay
marram10313883marram
naira5314743naira_
nairas6312783nairas
padnag1036073padnag
pagan86121163pag_an
paging104020403paging
pangram1239023pangram
para65242173pa_ra_
parae76335703pa_rae
parang93715513pa_rang
paras76143043pa_ras
parral85517533parral
rag45761323___rag
raga55930813rag_a_
ragas65326063rag_as
ragbags1135113ragbags
ragg65622693rag__g
raging85126433raging
raglan73711503raglan
ragman94013713ragman
ragtags935373ragtags
ratbag956563ratbag
sabra75317853sabra_
sabras85116363sabras
sacra74516993sacra_
sacral83414413sacral
saga55331173sag_a_
sagas66025883sag_as
saggar84010853saggar
saran53730303sa_ran
satrap86212553satrap
scrag85916173_scrag
sprag86418693_sprag
staging93818373staging
stalag7310023sta_lag
tabard9313333tabard
tabla73318363tabla_
tablas83716163tablas
tafia84215493tafia_
tafias93111963tafias
tag47259493t___ag
taggant9310223taggant
tagged93418123tagged
tagger84017703tagger
tagging103014913tagging
tags55545233tag__s
tahr75217153tahr__
tahrs85412333tahr_s
taiga64115663taiga_
taigas73712563taigas
taipan82410663taipan
taka87623593ta_ka_
takas95520683ta_kas
taking114725953taking
tala45938053ta_la_
talar56225383ta_lar
talars66021683talars
talas55935893ta_las
tallage82712073tallage
tamal73522623ta_mal
tamarao977593tamarao
tamarau9107063tamarau
tamari8313403tamari
tambac122210243tambac
tambak14249263tambak
taming94023433taming
tampan102512323tampan
tang56138673ta__ng
tanga64923693tanga_
tanging93419523tanging
tangrams1136163tangrams
tanka93817483tanka_
tankage12257773tankage
tankas104613763tankas
tannage8209583tannage
tanrec837803tanrec
tantra63713353tantra_
tantras73112093tantras
tapa65129143ta_pa_
tapas74627713ta_pas
taping94222393taping
tar37570693ta_r__
tarama8412733ta_rama
tardo65321103ta_rdo
tardy94720463ta_rdy
tare45957623ta_r_e
tared69340053ta_red
tares57456563ta_res
targe65227093ta_rge
targes74524593targes
target75028903target
taring73932283taring
tarmac10310333tarmac
tarn46842723ta_r_n
tarnal63716503tarnal
tarns56433953ta_rns
taro46846913ta_r_o
taroc75721643ta_roc
tarok97921073ta_rok
taros55640823ta_ros
tarot55943933ta_rot
tarp66936413ta_r_p
tarpan82814293tarpan
tarps76527113ta_rps
tarragon944673tarragon
tarre55825633ta_rre
tarred74720283tarred
tarres64723043tarres
tarring83318303tarring
tarry85422513ta_rry
tars46763953ta_r_s
tarsal63315273tarsal
tarsi55222173ta_rsi
tart47566183ta_r_t
tartan64217513tartan
tartar63214753tartar
tarts57242023ta_rts
tarty86328183ta_rty
tarzan152910753tarzan
tatar56122063ta_tar
tatars64619793tatars
tautaug883023tautaug
tautog765713tautog
tawing104521553tawing
taxa116820093ta_xa_
taxing143816713taxing
taxman15328613taxman
tazza1338083tazza_
tazzas1436283tazzas
teargas837013teargas
tegg65315923teg__g
tegua6109563tegua_
teguas768013teguas
terai53525483t_erai
terga63315643terga_
tergal72912833tergal
terra54419663terra_
terrae62915213terrae
terras63516973terras
tetra53417953tetra_
tetrad73612053tetrad
tetras63017623tetras
thiram1139963thiram
thorax1638253thorax
thraw1110515923t_hraw
tiara5315913tiara_
tiaras6314553tiaras
toga57027413tog_a_
togae67020113tog_ae
togas67823003tog_as
tora47545993t_ora_
torah87125273t_orah
toras55540373t_oras
trad55630913t__rad
tragi64717173t__ragi
tram67034553t__ram
trap67532803t__rap
tray77632593t__ray
trig55528163t__rig
trigram1077763trigram
trog57628213t__rog
trug55720043t__rug
tugrik1134283tugrik
vagal94613633vag_al
vagary1337333vagary
vagrant11410663vagrant
vagrom1235943vagrom
vara75530883va_ra_
varas86028193va_ras
waging114318383waging
washrag1444043washrag
wigwag1443723wigwag
zigzag1642963zigzag

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 Filter1786911127160.406440125.6
2DLD Change Limit1127162605.81319390.3
3Display Results2602600.0763421.1
 (SQL Overall)1786912606.29528386.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.