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

197 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
pitas7742767(None) 
ditas65923671ditas
litas54923771litas
pias66542551pi_as
picas94626521picas
pietas84516501pietas
pikas114218091pikas
pimas94725101pimas
pinas75434451pinas
pintas85021391pintas
pita65436431pita_
piths105817541piths
pits66348741pit_s
pittas86014521pittas
agitas7310592agitas
aits46355532ait_s
antas55432032antas
betas75528762betas
bias64738162bi_as
bimas95521742bimas
biotas84313922biotas
bites75641172bites
bits66148162bit_s
bitts75022592bitts
botas75328782botas
cites74435592cites
dita56032522dita_
dites66339152dites
dits56450522dit_s
divas95418582divas
etas46432272_etas
fetas85624402fetas
fiats85324482fiats
fits76043462fit_s
getas65421482getas
gigas75415582gigas
gites65630182gites
gits55744592git_s
hits75545132hit_s
iotas54821112iotas
its35538832_it_s
jotas125717442jotas
katas95922092katas
kinas95626912kinas
kites95432542kites
kiths125814972kiths
kits86441762kit_s
kivas124614732kivas
limas75627632limas
liras56021982liras
litai55216362litai
lits46252492lit_s
lotas55926302lotas
micas96823052micas
minas75434112minas
mites75141802mites
mitis75425992mitis
mitts75523752mitts
nipas77116672nipas
nites55736342nites
nits45741642nit_s
pacas96029402pacas
paisas84317492paisas
papas94927492papas
paras76143042paras
pas58775742p__as
pastas85422872pastas
pates76047892pates
paths105521382paths
pats66460852pat_s
peas65755062p_eas
peats76140192peats
petal76526892petal
petals84719812petals
pets66248332pet_s
pia56848032pi_a_
pial65636702pi_al
pian66136092pi_an
pians75126962pians
pibal95217322pibal
pibals103813082pibals
pica85831492pica_
pical95524372pical
picks135226142picks
pics85633912pi_cs
piers75926332piers
pies66949602pi_es
pieta75421752pieta_
pigs76634222pi_gs
pika106322952pika_
pikes115031032pikes
pikis115116392pikis
pilaf103923482pilaf
pilafs113511022pilafs
pilar75221502pilar
pilau73618522pilau
pilaus84114132pilaus
pilaw103913742pilaw
pilaws11399432pilaws
piles74742612piles
pilis75825202pilis
pills74130972pills
pilus75921062pilus
pima85428652pima_
pimps114616982pimps
pina65842632pina_
pinatas93711502pinatas
pines76048862pines
pings85830882pings
pinks115729382pinks
pinnas85315512pinnas
pins65558452pi_ns
pinta75727052pinta_
pintos86021292pintos
pints75936222pints
pions75826392pions
pious74621272pious
pipal95118352pipal
pipals104213642pipals
pipes96030142pipes
pips85837132pi_ps
pirns76020092pirns
pis56362032pi__s
pisos76021062pisos
piss65033332pi_ss
pistes85325632pistes
pit56471922pit__
pitaya1186602pitaya
pitayas1286262pitayas
pitch125018412pitch
pith95432692pit_h
pithy135614462pithy
pities83828082pities
pitman102412122pitman
pitmans11188742pitmans
piton76121582piton
pitons85319042pitons
pitsaw1135612pitsaw
pitsaws1234992pitsaws
pitta75018692pitta
pity96031932pit_y
pixes144323172pixes
pizzas1646982pizzas
plats75531372plats
pleas75627032pleas
potash1138272potash
pots66452362pot_s
prats76333392prats
primas104418102primas
proas75028802proas
psoas75012982psoas
pujas145513322pujas
pumas95121562pumas
punas74826752punas
pupas95219282pupas
puts65641752put_s
putts75719272putts
pyas96225702p_yas
raitas64417672raitas
rias45540592ri_as
riatas63915092riatas
rites54442552rites
rotas54827722rotas
sikas94617022sikas
simas75727552simas
sitar54820542sitar
sitars65417592sitars
sites56045432sites
sits45050202sit_s
situs55019232situs
spicas104715822spicas
spital83813872spital
spitals93011592spitals
spites84127332spites
spits74429552spit_s
tas38477102__tas
titan53318172titan
titans63414912titans
titis56023812titis
tits46145042tit_s
utas45924952_utas
vigas94817882vigas
vinas85126342vinas
visas84317652visas
vistas94513272vistas
vita75828522vita_
vitae84217632vitae
vital84819672vital
vitals94514302vitals
vivas114815022vivas
witan83816502witan
witans93412932witans
wites85536962wites
wits76044872wit_s
zetas145018162zetas
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.296603685.8
2DLD Change Limit538001971.40638264.6
3Display Results1971970.0464282.6
 (SQL Overall)1786911971.748102226.0
 
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.