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

149 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
periapt1131341(None) 
periapts1237271periapts
percept133112522percept
perhaps1446122perhaps
perianth1348552perianth
peridot10514242peridot
persalt9315412persalt
priapi1037922p_riapi
aerial64625713aeria_l
aerials74017553aerials
aeriest73924053aeriest
aperient10715153aperient
beleapt11310253beleapt
bewrapt14147133bewrapt
ceria75125363ceria__
cerias83321983ceria_s
ceriph1398463ceri_ph
defiant11311923defiant
derat65044083der_a_t
deviant11311313deviant
dript86923873_dri_pt
eeriest73620673eeriest
enrapt8313013_enrapt
errant6618733_errant
erupt74220063_er_upt
feria85922713feria__
feriae95618603feria_e
ferial94621253feria_l
ferias95020393feria_s
gript85126173_gri_pt
heliast10312073heliast
hereat93527413herea_t
heriot9422343heri_ot
lariat6629043laria_t
leapt75027473le__apt
mediant103516703mediant
mercapto1443313mercapto
merit7339183meri__t
operant9317223oper_ant
overapt12312653over_apt
parapet11317643par_apet
paraph13311263par_aph
parfait12312053parfait
pariah114320583paria_h
pariahs123812343pariahs
parian83223963paria_n
parians93519743parians
peart76440753pe__art
peasant9314923peasant
peat65967933pe__a_t
peccant13311733peccant
pedant9319493pe_dant
peltast9310513peltast
pendant10314853pendant
penial84120893penia_l
pennant9312493pennant
percale11314093percale
percent113520603percent
percepts14247643percepts
perea75026443perea__
pereia85217983pereia__
perfect141010833perfect
peri65636973peri___
perianths1445473perianths
periapses1346053periapses
periapsis1344833periapsis
pericarp1446123pericarp
pericarps1544473pericarps
pericope1447783pericope
peridia10312373peridia
peridots1138323peridots
perigee101113393perigee
perigon1039853perigon
peril75425953peri__l
periled10316323periled
perilla9311233perilla
perils84121853peri_ls
perinea9313043perinea
period9314983peri_od
periods10312243periods
peripatus1344933peripatus
peripety1546193peripety
periplast1387283periplast
peripter1278753peri_pter
perique1837523perique
peris75537073peri__s
perisarc1245363perisarc
perish114619063peri_sh
periti8319953peri_ti
peritus9311803peritus
periwig1345163periwig
perkiest143313243perkiest
permeant12310913permeant
permian112612283permia_n
permit10321683per_mit
perp89029893per__p_
perpent112318813perpent
perps95521483per__ps
persalts1038193persalts
persist9315853persist
pert66759323per___t
pertain92714963pertain
pertest9317043pertest
pervade1337023pervade
pervert12315583pervert
petit74332653peti__t
petnap1037423petnap_
petnaps1145033petnaps
pewit104622793pewi__t
pliant83918823p_liant
prat65952043p_r_a_t
preact103220393p_react
preadapt1346863preadapt
precast11314853precast
precept133112513precept
preempt1337723preempt
preriot9316413preri_ot
pretape113511623pretape
priapic1346023p_riapic
priapus1134353p_riapus
priest84125423p_riest
primp115615923p_rimp_
primps124711823p_rimps
print74837463p_ri_nt
privet113821343p_rivet
prompt12313013p_rompt
purist85525053puri_st
rapt67245313__r_apt
readapt1039743readapt
redipt94116743redi_pt
reliant7319243reliant
rewrapt12138113rewrapt
riant55833153__riant
script105717903scri_pt
serape84818413ser_ape
seraph114011163ser_aph
serial64625863seria_l
serials73919753serials
seriate73722473seriate
servant10313633servant
stript85222193stri_pt
teraph11319093ter_aph
trapt76433393_tr_apt
variant10316803variant
verdant11313293verdant
veriest103719133veriest
verist93823893veri_st
versant10313833versant
wrapt105123183_wr_apt

Search took 8 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 Filter1786911340270.393454684.5
2DLD Change Limit1340271497.39018136.3
3Display Results1491490.0632365.1
 (SQL Overall)1786911497.84622774.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.