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

253 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
puttying143495(None) 
juttying1933571juttying
putting103218571putt_ing
butting103519282butt_ing
cutting103817492cutt_ing
cuttling1138202cuttling
gutting93415922gutt_ing
guttling1037292guttling
hutting113016032hutt_ing
jettying1933952jettying
jutting153313712jutt_ing
nutting83316232nutt_ing
outlying1248812outlying
outvying1536062outvying
partying14168892partying
patting103722342patt_ing
petting103720952pett_ing
pettling1168212pettling
pitting103618872pitt_ing
pitying132910242p_itying
potting103720892pott_ing
prettying1536042prettying
punting103318442punt_ing
puttering122611642puttering
putzing19359122pu_tzing
rutting82718042rutt_ing
tutting83515912tutt_ing
untying1138942_untying
abutting1137003abutt_ing
autoing8314043au_toing
batting104422273batt_ing
battling113110493battling
betting103921403bett_ing
bitting103717293bitt_ing
bottling11279143bottling
buddying16274793buddying
bullying14329293bullying
bunting103718833bunt_ing
buoying13379953bu_oying
burying133413913bu_rying
busting104221793bust_ing
bustling112110063bustling
busying134211993bu_sying
butling103516813bu_tling
buttering122312523buttering
buttoning1246463buttoning
buying124213833bu__ying
catting103922643catt_ing
cuittling1234103cuittling
cullying14297503cullying
currying14196493currying
curtsying1543813curtsying
cuttings11277613cutt_ings
dirtying1336093dirtying
dittoing1036263dittoing
dotting93314483dott_ing
ducting113713593duct_ing
dueting93814393duet_ing
duetting1047183duetting
dummying17263723dummying
dunting93418383dunt_ing
dusting93618993dust_ing
emptying1634243emptying
fatting113818703fatt_ing
fetting113517873fett_ing
fettling1266773fettling
fitting113516563fitt_ing
futzing20307903fu_tzing
getting93316563gett_ing
gitting93215703gitt_ing
glutting10247643glutt_ing
gullying13367243gullying
gussying1334063gussying
gusting93917163gust_ing
guttering112410443guttering
guying11379723gu__ying
hatting113920233hatt_ing
hitting113017273hitt_ing
hogtying1633553hogtying
hotting113116523hott_ing
hunting114317123hunt_ing
hurrying15145533hurrying
hurting113914033hurt_ing
hurtling12318313hurtling
hustling12228793hustling
hutching17318643hutching
inputting1235823inputt_ing
jetting153815343jett_ing
jotting152912773jott_ing
jurying18337763ju_rying
justing153615163just_ing
justling16207253justling
kitting123214443kitt_ing
kittling1336063kittling
letting83218533lett_ing
lotting82917753lott_ing
lunting83817743lunt_ing
lusting83619323lust_ing
lustring9269723lustring
luting75221753lu_t_ing
matting103620143matt_ing
mottling11197753mottling
muddying16254543muddying
mummying15263723mummying
munting103718773munt_ing
musting103221073must_ing
mutating112211753mutating
muting93921523mu_t_ing
mutining11310493mutining
mutinying1545333mutinying
muttering122611323muttering
netting84018763nett_ing
nettling957213nettling
nutating92411953nutating
nuttings9276783nutt_ings
ousting84021353oust_ing
outbuying1545563outbuying
outcrying1576093outcrying
outdoing1039423outdoing
outflying1635343outflying
outgoing1039273outgoing
outing74128153ou_t_ing
outlaying1338543outlaying
outpitying1644773outpitying
outring84021023ou_tring
outsaying1338703outsaying
outsing83320463ou_tsing
outstaying1446093outstaying
outswing1259283outswing
outthink1545583outthink
palsying1436233palsying
pandying15217663pandying
panting104025423pant_ing
parrying14168133parrying
parting103527383part_ing
pasting103826553past_ing
patching163212753patching
patining11312303patining
pattering122314423pattering
paying123722163p__aying
pelting102917273pelt_ing
pestling111010253pestling
petering112516813petering
pettings11349703pett_ings
phonying1745833phonying
photoing1439073photoing
pitching163411113pitching
pithing134014053p_ithing
pittings11349123pitt_ings
plating103823073plat_ing
platting114813033platting
playing133816093p_laying
plotting113011013plotting
plotzing20276153plotzing
ploying132811573p_loying
plying124312083p__lying
ponying133312123p_onying
porting103021783port_ing
posting105622243post_ing
pottering122612003pottering
pouting103519943pout_ing
prating103424453prat_ing
prattling1246303prattling
praying133717323p_raying
pretyping1764943pretyping
preying133114553p_reying
prying124114803p__rying
pudding124010803pu_dding
puddling13218033puddling
puffing162910943pu_ffing
pugging122912543pu_gging
puking133913063pu__king
puling93621403pu__ling
pulling103821073pu_lling
pulping123612323pu_lping
pulsing103712863pu_lsing
pumicing1535843pumicing
pumping144213553pu_mping
punching163310123punching
pungling12228663pungling
punning103414993pu_nning
pupating1337683pupating
pupping114412503pu_pping
pureeing1137273pureeing
purfling1467763purfling
purging113314183pu_rging
purifying1835853purifying
purling103620293pu_rling
purpling1368543purpling
purring104515823pu_rring
pursing103715553pu_rsing
pursuing1146233pursuing
purveying1843573purveying
pushing133615453pu_shing
putamina1244543putamina
putrefying1942953putrefying
putti76018743putt_i__
puttie84116303putt_i_e
puttied103811163putt_ied
puttier93314503putt_ier
putties94420023putt_ies
putty104721403putty___
puttylike1841813puttylike
puzzling19225393puzzling
querying2135243querying
quitting18228833quitting
quoting17310043quot_ing
ratting83822363ratt_ing
rattling92510873rattling
retrying122410453retrying
retting83425883rett_ing
retying113213833_retying
rotting82919683rott_ing
rubying13297933ru_bying
rusting83821263rust_ing
rustling9249983rustling
scuttling1234243scuttling
setting83621393sett_ing
settling978943settling
shutting12309693shutt_ing
shuttling1334293shuttling
sitting83519633sitt_ing
smutting11278063smutt_ing
spatting113111763spatt_ing
spitting113012323spitt_ing
spotting112812093spott_ing
spurting113111633spurt_ing
sputtering13106463sputtering
staying114017323_staying
studying1335553studying
stying105414573__stying
suiting83419003suit_ing
sullying12328513sullying
suturing9310373suturing
tatting84019523tatt_ing
tattling9259473tattling
totting82816843tott_ing
toying105017303__toying
trying104214073__trying
tufting11289873tuft_ing
turtling9238833turtling
tutoring938433tutoring
tying96019843___tying
undying1238503_undying
updrying1534013updrying
uttering91613083_uttering
vatting113614853vatt_ing
vetting114216563vett_ing
vittling1236143vittling
wattling12258783wattling
wetting114117383wett_ing
witting113417063witt_ing
wotting112913843wott_ing

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 Filter1786911461620.420425454.8
2DLD Change Limit1461622538.67316852.5
3Display Results2532530.0932720.4
 (SQL Overall)1786912539.18619452.5
 
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.