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

212 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
gargety1238804(None) 
gadgety13356161gadgety
garget84327271garget_
gargets94614571gargets
gadget93616182gadget_
gadgetry14263212gadgetry
gadgets10348682gadgets
gaiety10119372ga_iety
garnet73928412garnet_
garnets84115402garnets
garret74426562garret_
garrets84413622garrets
garvey13127872garve_y
gayety13116382ga_yety
gorget87123862gorget_
gorgets94711782gorgets
largely1136702largely
parget94529392parget_
pargets105215192pargets
target75028902target_
targets84314222targets
variety1337742variety
arete56031353_ar_ete
argent74023663_argent
argents84014853_argents
argosy1036423_argosy
argot67728653_argot_
argots74116033_argots
argufy1344093_argufy
armet76739453_armet_
armets84918353_armets
artery9911453_artery
arty77531313_ar__ty
barbet104427883barbet_
barbets114915843barbets
barely114716793bar_ely
barge85631023barge__
barged105822643barge_d
bargee94624443barge_e
bargees105415873bargees
barges94528253barge_s
barley115116763barle_y
barney115314453barne_y
barret84930483barret_
barretry13115183barretry
barrets94917103barrets
biggety1434433biggety
cagey115917823ca_ge_y
caret75360563car_et_
carets85330773car_ets
carnet84732873carnet_
carnets93918403carnets
carney115315703carne_y
carpet104530093carpet_
carpets113915333carpets
carroty1248943carroty
darkey145212423darke_y
faggoty1542863faggoty
ferrety13287013ferrety
fidgety15384893fidgety
forgery14419303forgery
forget106326393forget_
forgets113813793forgets
furmety1534813furmety
gage65936103ga_ge__
gaged85522313ga_ge_d
gager74726293ga_ge_r
gagers84021333ga_gers
gages74529973ga_ge_s
gagged104817153gagge_d
gagger95016513gagge_r
gaggers103413663gaggers
gallery11468743gallery
gallet73630853gallet_
galleta8399653galleta
gallets83517403gallets
galley104215453galle_y
gamely124711913ga_mely
gamete9313593ga_mete
gamey115320553ga_me_y
ganged94619193gange_d
ganger83721463gange_r
gangers94418603gangers
gangly113911583gang_ly
gangsta944513gangsta
gangway1544233gangway
gannet74321853gannet_
gannets83811443gannets
garage8314513garage__
garaged1039253garage_d
garages9314113garage_s
garbagey1543373garbage_y
garbagy1444243garbagy
garbed104815663garbe_d
garden84215083garde_n
gardens93312093gardens
garganey1344883garganey
gargle84215463garg_le
gargled104210673gargled
gargler93710263gargler
garglers10418263garglers
gargles94214893gargles
garment10315233garment
garments1139963garments
garner73917003garne_r
garners83815983garners
garote7717953gar_ote
garoted9710133garoted
garotes8614563garotes
garotte868703garotte
garred85217413garre_d
garreted1057523garreted
garrote8510103garrote
garter74420513garte_r
garters84218233garters
garth94720223gar__th
garveys14124463garveys
gaseity1135113gaseity
gasket114417253gasket_
gaskets12348153gaskets
gaudery1234743gaudery
gauge76117903gauge__
gauged94713473gauge_d
gauger84714853gauge_r
gaugers94211713gaugers
gauges85915993gauge_s
gingely12378213gingely
gingery12368913gingery
gleety10479193g_leety
gorge76423893gorge__
gorged95016983gorge_d
gorgedly1444003gorgedly
gorger86116983gorge_r
gorgers94813643gorgers
gorges85321893gorge_s
gorgeted1135353gorgeted
grapery13457953grapery
grapey126012303grape_y
gravely14469063gravely
gravity1437183gravity
greedy11518853g_reedy
greeny104811453g_reeny
greet65835323g_reet_
greets75117423g_reets
grey85624043g_r_e_y
gritty10338403g_ritty
grotty10389833g_rotty
grouty104710983g_routy
guaranty1244153guaranty
gurge75419783gurge__
gurged95513363gurge_d
gurges84716863gurge_s
gurglet94412033gurglet_
gurglets10355543gurglets
gurnet74920873gurnet_
gurnets84010793gurnets
gurney10429413gurne_y
haughty17334643haughty
jaggery19336903jaggery
jargony1834493jargony
jarvey19135403jarve_y
larceny1234853larceny
large65325463large__
larger74417513large_r
larges74824233large_s
largess8408913largess
largest83715103largest
maggoty1444013maggoty
mangey123614523mange_y
margay12310593marg_ay
marge85328333marge__
margent10316693margent
margents11410133margents
marges94525713marge_s
market123226043market_
markets133314033markets
naivety1344283naivety
naughty14445623naughty
nuggety1234313nuggety
parge85831853parge__
parged104922043parge_d
parges94529543parge_s
pargeted1238683pargeted
parity114719873par_ity
parley116718363parle_y
parroty1247863parroty
party106630613par__ty
paughty16294323paughty
rackety16499113rackety
raggedy13334663raggedy
rarefy12296343rar_efy
rarely93513653rar_ely
rarity93615493rar_ity
safety12206913sa_fety
sagely102811383sa_gely
sarge65531133sarge__
sarges75128593sarge_s
satiety1038203satiety
surety93515013sur_ety
surgery11319213surgery
targe65227093targe__
targes74524593targe_s
targeted1037483targeted
tarty86328183tar__ty
tragedy1234793tragedy
varlet9423503varlet_
varletry1443453varletry
varlets10411573varlets
varsity1356673varsity
waggery15276903waggery
warty119323823war__ty
yarely122810303yar_ely

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.406440125.6
2DLD Change Limit1340272126.15621771.8
3Display Results2122120.0762789.5
 (SQL Overall)1786912126.63826919.4
 
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.