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

115 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
gadgety1335616(None) 
gadget93616181gadget_
gadgetry14263211gadgetry
gadgets10348681gadgets
gargety12388041gargety
fidgety15384892fidgety
gaiety10119372ga_iety
garget84327272garget_
gargets94614572gargets
gayety13116382ga_yety
badge94819693badge__
badged114814793badge_d
badger105415083badge_r
badgerly1543283badgerly
badgers114812653badgers
badges103917373badge_s
biggety1434433biggety
budget104618123budget_
budgets11489863budgets
cadet85339343cad_et_
cadets96316513cad_ets
cadge94018793cadge__
cadged114812343cadge_d
cadger105013913cadge_r
cadgers114712003cadgers
cadges104716713cadge_s
cadgy125210783cadg__y
cagey115917823ca_ge_y
dodgery13627783dodgery
fadge104817003fadge__
fadged124712363fadge_d
fadges114814033fadge_s
faggoty1542863faggoty
fidget114216483fidget_
fidgets12388763fidgets
gadded103913173gadde_d
gadder93714713gadde_r
gadders103611503gadders
gadfly1434663gad_fly
gadgeteer1242413gadgeteer
gadje1457743gadje__
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
garnet73928413garnet_
garnets84115403garnets
garret74426563garret_
garrets84413623garrets
garvey13127873garve_y
gaseity1135113gaseity
gasket114417253gasket_
gaskets12348153gaskets
gaudery1234743gaudery
gauge76117903gauge__
gauged94713473gauge_d
gauger84714853gauge_r
gaugers94211713gaugers
gauges85915993gauge_s
gingely12378213gingely
gingery12368913gingery
gleety10479193g_leety
godet7530043god_et_
godets8410933god_ets
gorget87123863gorget_
gorgets94711783gorgets
gudgeon10123743gudgeon
haughty17334643haughty
jaggery19336903jaggery
largely1136703largely
maggoty1444013maggoty
mangey123614523mange_y
midget103718453midget_
midgets113910253midgets
naivety1344283naivety
naughty14445623naughty
nidget83715643nidget_
nidgets9358143nidgets
nuggety1234313nuggety
parget94529393parget_
pargets105215193pargets
paughty16294323paughty
rackety16499113rackety
raggedy13334663raggedy
safety12206913sa_fety
sagely102811383sa_gely
satiety1038203satiety
target75028903target_
targets84314223targets
variety1337743variety
wadset10314303wadset_
wadsets1136443wadsets
waggery15276903waggery
widget113815263widget_
widgets12318453widgets

Search took 8 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.440406115.9
2DLD Change Limit1340271157.26318453.4
3Display Results1151150.0333484.8
 (SQL Overall)1786911157.73623098.6
 
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.