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

173 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
persalt931541(None) 
persalts1038191persalts
desalt7518312de_salt
oversalt11312742oversalt
peasant9314922peasant
percale11314092percale
periapt11313412periapt
persist9315852persist
perusal939192perusal_
perusals1047142perusals
presale9416352presale
versal93013752versal_
versant10313832versant
aerial64625713aerial_
aerials74017553aerials
aerosat7417183aerosa_t
basalt83519583_basalt
bursal84414823bursal_
cercal10314123cercal_
cereal8315833cereal_
cereals9313173cereals
dealt65234283de__alt
derat65044083der_a_t
dermal93614343dermal_
desalts839573de_salts
dorsal74613943dorsal_
dorsals84110843dorsals
errant6618733_errant
ersatz1536653_ersatz
erst47436433_ers__t
exalt123018533_e_xalt
feral85424653fer_al_
ferals94216643fer_als
ferial94621253ferial_
gestalt8411163gestalt
herald10311343her_ald
herbal112513493herbal_
herbals122710603herbals
hereat93527413herea_t
herself1337623herself
jessant1438443jessant
marsala939583marsala
mensal84615653mensal_
operant9317223oper_ant
oversale11313873oversale
oversalts1238163oversalts
oxysalt1743513oxysalt
parfait12312053parfait
parral85517533parral_
parrals94414573parrals
parsable12311693parsable
passant9813943passant
pausal81511963pausal_
peal68648103pe__al_
peals75235493pe__als
peart76440753pe__art
peasants1038263peasants
peat65967933pe__a_t
peccant13311733peccant
pedal86022503pe_dal_
pedalo93811153pe_dalo
pedals94316033pe_dals
pedant9319493pe_dant
pelt67651083pe___lt
peltast9310513peltast
penal75228373pe_nal_
penalty1267743pe_nalty
pendant10314853pendant
penial84120893penial_
pennant9312493pennant
pensil83013333pensil_
pensile92713543pensile
pensils92811593pensils
penult8314653pe_nult
peptalk1554823peptalk
percales12313803percales
percent113520603percent
percept133112523percept
perea75026443perea__
perfect141010833perfect
pergola1067623pergola
perhaps1446123perhaps
perianth1348553perianth
periapts1237273periapts
peridot10514243peridot
peril75425953per_il_
perilla9311223perilla
perils84121853per_ils
perisarc1245363perisarc
perkily1637803perkily
permeant12310913permeant
permit10321683per_mit
peroral9314793peroral_
perpent112318803perpent
perse75429523pers__e
perses85428063pers_es
persists1049183persists
person83517873pers_on
persona92812453persona
personal102311573personal_
personals11238573personals
personalty1555283personalty
persons93717013persons
perspex1834173perspex
persuade1145853persuade
pert66759323per___t
pertain92714963pertain
pertest9317043pertest
pertly115312543per_tly
perusable1347453perusable
pervade1337023pervade
pervert12315583pervert
pesade9311103pe_sade
pessary1246873pessary
pest65555293pe_s__t
pestle83215843pe_stle
petal76526893pe_tal_
petals84719813pe_tals
petrale9312623petrale
petrosal1047153petrosal_
petsai838083petsa_i
petsais938433petsais
pheasant1347083pheasant
phrasal1246163phrasal_
pissant91012503pissant
pleasant1048323pleasant
portal84218463portal_
portals94015563portals
prat65952043p_r_a_t
preact103220393p_react
precast11314853precast
premolt11312073premolt
presa74319043presa__
presage10312293presage
presales10315263presales
presell939293presell
present94022733present
preset84430983pres_et
presift12312223presift
presold1059603presold
presort95219533presort
presplit1247753presplit
prest75736353pres__t
psalm949273p__salm
pulsant9310563pulsant
pursily1238213pursily
pursuant1046563pursuant
pursuit948273pursuit
resale64025543re_sale
resat55139683re_sa_t
result6318223re_sult
salt45758523___salt
seral56336383ser_al_
serial64625863serial_
serials73919743serials
serosal7311153serosal_
serval93913413serval_
servals103410743servals
servant10313623servant
supersale11411323supersale
tarsal63315273tarsal_
tarsals72512603tarsals
tergal72912833tergal_
tersely1038103tersely
tersest71713993tersest
verbal112513663verbal_
verbals121910743verbals
verdant11313293verdant
vernal93514213vernal_
versants1137783versants
verset94327323vers_et
verst84429373vers__t
wergelt1138583wergelt

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.1561145455.1
2DLD Change Limit1340271737.18618651.1
3Display Results1731730.0632746.0
 (SQL Overall)1786911737.40524131.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.