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

154 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
piths10581754(None) 
kiths125814971kiths
paths105521381paths
pitas77427671pitas
pith95432691pith_
pithy135614461pithy
pits66348741pit_s
airths95414252airths
aits46355532ait_s
baths105922922baths
beths105519222beths
births115713602births
bites75641172bites
bits66148162bit_s
bitts75022592bitts
briths115113862briths
cites74435592cites
ditas65923672ditas
dites66339152dites
dits56450522dit_s
eths76619522_eths
faiths124610272faiths
fifths15406542fifths
filths12389782filths
firths125113502firths
fits76043462fit_s
friths124313582friths
girths105612272girths
gites65630182gites
gits55744592git_s
goths96513002goths
griths105211652griths
heths116317782heths
highs125412522highs
hits75545132hit_s
ichs96214712_ichs
its35538832_it_s
kites95432542kites
kith115826352kith_
kithe125917452kithe
kithes135016652kithes
kits86441762kit_s
laths86022402laths
litas54923772litas
lithe84922012lithe
litho86513782litho
lithos94212552lithos
lits46252492lit_s
maths105624022maths
meths105320232meths
mirths114912992mirths
mites75141802mites
mitis75425992mitis
mitts75523752mitts
moths106021552moths
myths135911602myths
nighs95013612nighs
ninths936932ninths
nites55736342nites
nits45741642nit_s
oaths86117312oaths
pates76047892pates
path99134912path_
pathos115516692pathos
pats66460852pat_s
pechs125516202pechs
pehs95625762p_ehs
pets66248332pet_s
pians75126962pians
pias66542552pi_as
picas94626522picas
picks135226142picks
pics85633912pi_cs
piers75926332piers
pies66949602pi_es
pietas84516502pietas
pigs76634222pi_gs
pikas114218092pikas
pikes115031032pikes
pikis115116392pikis
piles74742612piles
pilis75825202pilis
pills74130972pills
pilus75921062pilus
pimas94725102pimas
pimps114616982pimps
pinas75434452pinas
pines76048862pines
pings85830882pings
pinks115729382pinks
pins65558452pi_ns
pintas85021392pintas
pintos86021292pintos
pints75936222pints
pions75826392pions
pious74621272pious
pipes96030142pipes
pips85837132pi_ps
pirns76020092pirns
pis56362032pi__s
pish96127912pish_
pishes114722102pishes
pisos76021062pisos
piss65033332pi_ss
pistes85325632pistes
pit56471922pit__
pita65436432pit_a
pitch125018412pitch
pitches143617752pitches
pitchy16479672pitchy
pithed124615612pithed
pities83828082pities
piton76121582piton
pitons85319042pitons
pitta75018692pitta
pittas86014522pittas
pity96031932pit_y
pixes144323172pixes
plinths1236122plinths
poohs103915712poohs
pothos114214692pothos
pots66452362pot_s
puts65641752put_s
putts75719272putts
rites54442552rites
ruths85714642ruths
sighs95416742sighs
sinhs86719602sinhs
sites56045432sites
sith75435152sith_
sits45050202sit_s
situs55019232situs
sixths16416372sixths
smiths114711022smiths
soths86218632soths
spilths12356022spilths
spites84127332spites
spits74429552spit_s
teths85418512teths
tilths9459372tilths
tithe85319702tithe
tithes94720212tithes
titis56023812titis
tits46145042tit_s
widths1335122widths
wites85536962wites
with105730472with_
withe115220232withe
withes124620842withes
withy144813762withy
wits76044872wit_s
yirths12639532yirths
zitis145815582zitis
zits136030292zit_s

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 Filter178691538000.310576422.6
2DLD Change Limit538001541.50035866.7
3Display Results1541540.0463347.8
 (SQL Overall)1786911541.85696277.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.