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 “putts” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

168 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
putts7571927(None) 
butts75824251butts
mutts75120251mutts
punts75828001punts
puts65641751pu_ts
putt66937841putt_
putti76018741putti
putto75617661putto
putty104721401putty
aunts55227632aunts
autos56523322autos
batts76727562batts
bitts75022592bitts
botts75224862botts
bunts75729802bunts
busts75227692busts
butes714535872butes
buts67247692bu_ts
butt65143742butt_
butte74924292butte
buttes84822562buttes
butty104020112butty
bututs8409422bututs
cults75022552cults
cunts76125122cunts
cutes79438322cutes
cutis77723762cutis
cuts65841152cu_ts
cutty105417222cutty
ducts85319892ducts
duets65323882duets
duits65021882duits
dunts65828412dunts
dusts65923562dusts
gusts65722792gusts
guts56637252gu_ts
gutta64613382gutta
gutty94516992gutty
hunts86826172hunts
hurts86922822hurts
huts76737442hu_ts
justs124918262justs
jutes125125132jutes
juts115930162ju_ts
jutty154914642jutty
lunts55826902lunts
lusts55022802lusts
lutes55836662lutes
matts76829182matts
mitts75523752mitts
motts76527002motts
musts75527442musts
mutes75033782mutes
muts64839982mu_ts
mutt65739402mutt_
netts55320722netts
nuts45032672nu_ts
nutty84816872nutty
ousts55225702ousts
outs45746962ou_ts
pacts95125802pacts
pants76536922pants
parts77743372parts
pasts75936502pasts
pates76047892pates
paths105521382paths
pats66460852p_ats
patty104723612patty
peats76140192peats
pelts76128812pelts
pests75933272pests
pets66248332p_ets
petti75119452petti
petto76021042petto
petty105320292petty
phots105418502phots
phuts104613502phuts
pints75936222pints
pitas77427672pitas
piths105817542piths
pits66348742p_its
pitta75018692pitta
pittas86014522pittas
plats75531372plats
plots75025672plots
poets76024442poets
ports75934592ports
posts75228782posts
pots66452362p_ots
potto75320942potto
pottos84615872pottos
potty105621002potty
poults84613482poults
pouts75530322pouts
prats76333392prats
pubes94423402pubes
pubis94616472pubis
pubs85029212pu_bs
puces94924632puces
pucks134322102pucks
puds75630512pu_ds
puffs134114932puffs
pugs76332772pu_gs
pujas145513322pujas
pukes114523022pukes
pules74538812pules
pulis74225602pulis
pulls74425052pulls
pulps95116482pulps
puls65437562pu_ls
pumas95121562pumas
pumps115520602pumps
punas74826752punas
pungs85422222pungs
punks114822682punks
puns66641482pu_ns
punt65747202punt_
punto75121322punto
puntos85915792puntos
punty106021612punty
pupas95219282pupas
pups86032232pu_ps
pupus94614042pupus
puris75332022puris
purls74723352purls
purrs75320432purrs
purs65641042pu_rs
purty105019402purty
pus55547842pu__s
puses75532202puses
puss64830132pu_ss
put55759072pu_t_
puton73617912puton
putons83515152putons
putouts937082putouts
putted94220252putted
puttee85919722puttee
puttees93612912puttees
putter83921442putter
putters94219192putters
puttie84116302puttie
putties94420022putties
putz158326322pu_tz
putzes174212522putzes
quits144122352quits
runts55927632runts
rusts55026992rusts
ruths85714642ruths
ruts44541492ru_ts
rutty85617802rutty
setts55124322setts
spurts84814972spurts
suets55126102suets
suits55028052suits
sutta54015332sutta
suttas63813792suttas
tufts85713272tufts
tuts45838452tu_ts
tutti54614672tutti
tuttis63611372tuttis
tutty85217022tutty
tutus55214812tutus
utas45924952_utas
utes45930882_utes
uts35534372_u_ts
watts86923092watts
yetts86715132yetts
yurts87216532yurts

Search took 3 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 Filter178691538000.310576422.6
2DLD Change Limit538001681.61033416.1
3Display Results1681680.0931806.5
 (SQL Overall)1786911682.01388768.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.