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

220 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
pith9543269(None) 
kith115826361kith
path99134911path
pish96127911pish
pit56471921pit_
pita65436431pita
pitch125018411pitch
piths105817541piths
pithy135614461pithy
pits66348741pits
pity96031931pity
sith75435151sith
with105730471with
airth85621022airth
ait38093902ait_
aitch105216162aitch
aits46355532aits
apish105116632apish
baith108023132baith
bath95940082bath
beth96629232beth
birth105619872birth
bit57070902bit_
bitch125017762bitch
bite66547002bite
bits66148162bits
bitt65545812bitt
both96533432both
brith104924372brith
cite65640342cite
city95122622city
dish86328332dish
dit47071332dit_
dita56032522dita
ditch115015092ditch
dite55547552dite
dits56450522dits
ditz146929512ditz
doth86225712doth
eath75735662eath
eth66630982_eth
faith115620852faith
fifth145210922fifth
filth115015822filth
firth115819532firth
fish106926272fish
fit66365452fit_
fitch134816872fitch
fits76043462fits
frith115922032frith
girth95618842girth
git46266052git_
gite55438612gite
gits55744592gits
goth86825082goth
grith95520372grith
hath105933912hath
heth107028022heth
high116619922high
hit66569192hit_
hitch134515472hitch
hits75545132hits
ich86227742_ich
it28455682_it_
itch95619172_itch
its35538832_its
kit78559882kit_
kite85338242kite
kithe125917452kithe
kiths125814972kiths
kits86441772kits
laith85722102laith
lath76640382lath
lich96230842lich
lit39377312lit_
lite47054542lite
lithe84922012lithe
litho86513782litho
lits46252492lits
litu47631562litu
loth76132132loth
math95437452math
meth95827842meth
mirth106418892mirth
mite66249412mite
mitt66145492mitt
mity95528212mity
moth96731332moth
myth126715432myth
nigh85220662nigh
ninth8314582ninth
nit37065942nit_
nite45943582nite
nits45741642nits
nth66320592_nth
oath76132152oath
pah88853592p_ah
pash95638132pash
pat58089462pat_
patch125221222patch
pate65350462pate
paths105521382paths
pats66460852pats
paty95234562paty
pech116125452pech
peh86740962p_eh
pet56477302pet_
pets66248332pets
pht86030522pht_
pi48145362pi__
pia56848032pi_a
pial65636702pial
pian66136092pian
pias66542552pias
pic76046822pi_c
pica85831492pica
pice84641092pice
pick125933812pick
pics85633912pics
pie55457402pi_e
pied75035362pied
pier66035292pier
pies66949602pies
pieta75421752pieta
piety105817302piety
pig65744972pi_g
pigs76634222pigs
pika106322952pika
pike106335212pike
piki106520562piki
pile65649692pile
pili66130352pili
pill65339462pill
pily96132732pily
pima85428652pima
pimp106024902pimp
pin57066722pi_n
pina65842632pina
pinch125619302pinch
pine67755712pine
ping75943592ping
pink107039382pink
pins65558452pins
pint66963172pint
pinta75727052pinta
pinto75625752pinto
pints75936222pints
piny911838352piny
pion67235292pion
pip78051042pi_p
pipe86434432pipe
pips85837132pips
pipy115421512pipy
pirn67128372pirn
pis56362032pi_s
piso66727562piso
piss65033332piss
piste75824602piste
pitas77427672pitas
pitchy16479672pitchy
pithed124615612pithed
piton76121582piton
pitta75018692pitta
piu56639542pi_u
pix126437932pi_x
pixy166117762pixy
plinth11310452plinth
poh86740532p_oh
pooh96027382pooh
posh95427322posh
pot58078432pot_
pots66452362pots
pst57932512pst_
pugh106619232pugh
push95526622push
put55759072put_
puts65641752puts
putt66937842putt
putz158326322putz
rath76037662rath
rich97025542rich
rite45849452rite
ritz135129982ritz
ruth76825992ruth
saith85826552saith
sidh86222992sidh
sigh85625892sigh
sinh76238042sinh
sit35877752sit_
site47052412site
sits45050202sits
sixth155512232sixth
smith107818052smith
soth75932522soth
spilth11469732spilth
spit65545082spit_
spite75430662spite
spits74429552spits
spitz166017972spitz
swith115917402swith
teth76327892teth
tilth85515362tilth
tit36771052tit_
tithe85319702tithe
titi47130622titi
tits46145042tits
vita75828522vita
wich125724742wich
width12310962width
wish107228732wish
wit66563772wit_
witch134517562witch
wite75443272wite
withe115220232withe
withy144813762withy
wits76044872wits
yirth116513752yirth
zit126049992zit_
ziti136022372ziti
zits136030292zits

Search took 2 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 Filter178691298720.313570897.8
2DLD Change Limit298722200.98330388.6
3Display Results2202200.0633492.1
 (SQL Overall)1786912201.359131487.1
 
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.