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

174 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
peripter127875(None) 
peripters1368121peripters
hemipter1545582hemipter
perimeter1349562perimeter
peripety1546192peripety
periphery1943842periphery
permitter1345962permitter
persister1146832persister
perter84422282per__ter
printer93917302p_rinter
scripter12137782scripter
abrupter1243793abrupter
aerier64823153aeri__er
cerite84724873ceri_te_
cerites94823433ceri_tes
critter94113033_critter
decipher1644423decipher
demister11310223demister
depicter1356853depicter
derider93214973deri_der
deringer1038143deringer
deriver114213913deri_ver
drifter11348703_drifter
dripper12349233_dripper
eerier64320023eeri__er
emitter93211083_emitter
erecter93113393_erecter
erupted10207163_erupted
ferreter1136543ferreter
fritter103912773_fritter
grifter113810493_grifter
griper94114613_grip_er
gripier103210323_gripier
gripper124410713_gripper
grister83915413_grister
gritter83913353_gritter
heister103613623he_ister
hemipters1645683hemipters
heritor10310563heri_tor
keister113011573ke_ister
leister73212753le_ister
meister93114163me_ister
meristem1245743meristem
merited10313853meri_ted
painter93814563p_ainter
parietes10714543parietes
parroter1058203parroter
pearter9412743pe_arter
peeper103614803pe_ep_er
pelite84323003peli_te_
pelites93821993peli_tes
pelter83321623pe__lter
penster92811953pe_nster
peopler1138083pe_opler
pepper93512943pe__pper
peppier10268323pe_ppier
percher143313423per_cher
perfecter1646043perfecter
perfumer1574553perfumer
periapses1346053periapses
periapt11313413periapt__
periapts1237273periapt_s
periblem1445513periblem
periderm1346803peri_derm
perigee101113393peri_gee
perigees1189503perigees
periled10316323peri_led
perilled11410113perilled
perimeters1448603perimeters
perimetry1646503perimetry
perinea9313033peri_nea
periostea1144783periostea
periotic12313443periotic
peripatus1344933peripatus
peripeteia1453323peripeteia
peripetia1346653peripetia
peripeties1448393peripeties
peripheral1754213peripheral
perique1837523perique_
periques1937653periques
perished14310083perished
perishes13313753perishes
periti8319953peri_t_i
peritus9311803peri_tus
perjurer17285903perjurer
perkier133813123per_kier
perlite9317323perlite_
perlites10316363perlites
permitted1446653permitted
permittee1346683permittee
permitters1444623permitters
permute1138793permute_
permuted1336713permuted
permutes1238713permutes
perplex1836153per_plex
persisted1247143persisted
persisters1246273persisters
perspex1834183persp_ex
perspire1246663perspire
peruser93511373per_user
pervader1444863pervader
perverter1445563perverter
pester84827593pe__ster
peter74427593pe___ter
petite84320653peti_te_
petites93820203peti_tes
petrifier1447123petrifier
petter83924773pe__tter
pewter114013673pe__wter
philter12108213p_hilter
piper96523193p__ip_er
pipier104913983p__ipier
plaister1068013plaister
plaiter93615393plai_ter
pointer93814933p_ointer
politer92417073poli_ter
porter84224413por__ter
prater84825353p_r_ater
prealter1048863prealter
preppier1156643preppier
prester93519623p_rester
pricer103918293p_ri_cer
pricier113313113p_ricier
pricker154013413p_ricker
prier75027763p_ri__er
primer105118683p_ri_mer
primmer134310163p_rimmer
prinker133412743p_rinker
printed104016373p_rinted
printers103214903p_rinters
printery13318433p_rintery
privater13158533p_rivater
privier122910453p_rivier
prizer174714883p_ri_zer
prompter1437983prompter
proper104319953p_rop_er
purifier1338573purifier
purpler11289273pur_pler
pyrite11913313pyri_te_
pyrites12812203pyri_tes
reciter94117263reci_ter
refilter1137153refilter
register939553register
reinter73116843re_inter
remitter102810323remitter
reprinter1197353reprinter
resister8311653resister
rewriter1137923rewri_ter
rioter64817283__rioter
riper74328403__rip_er
ripper103518653__ripper
ritter63822423__ritter
scripted13117553scripted
scripters13116683scripters
seriate73722473seriate_
seriated92717023seriated
seriates82620673seriates
sprinter103810813sprinter
stricter1039423stricter
striper94514793strip_er
stripier1058863stripier
stripper1247123stripper
tempter11358213te_mpter
tripper113711923_tripper
triter65120593_tri_ter
unriper9188283unrip_er
verditer1236223verditer
verier94620963veri__er
verifier14159203verifier
verite94323443veri_te_
verites103822263veri_tes
writer94416513_wri_ter
yperite1249893yperi_te_
yperites13310153yperi_tes

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 Filter1786911461620.500357382.0
2DLD Change Limit1461621746.51622431.2
3Display Results1741740.0762289.5
 (SQL Overall)1786911747.09225196.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.