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

129 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
pessary124687(None) 
essay867622_essa_y
peccary1636282peccary
pedlary13277542pedlary
piscary1437422piscary
accessary1652723accessary
assay8710283_assa_y
beggary14316153beggary
bestiary1344813bestiary
beswarm1445783beswarm
beweary1536223beweary
bursary12397583bursary
cedary12419603ce_dary
deary95826843de__ary
denary105316863de_nary
descry1256183de_scry
dessert82916453dessert
emissary1343473emissary
escar74011993_escar_
escarp10449003_escarp
escars83913133_escars
eskar9457453_eskar_
eskars10357593_eskars
essays965653_essays
estray95713333_estray
estuary1034683_estuary
feodary1444713feodary
feudary1444273feudary
glossary1243373glossary
hussar9317283hussar_
hussars10326983hussars
jessant1438443jessant
leary85927383le__ary
lesser63514853lesser_
lessor64010603lessor_
lessors73610523lessors
message1037833message
messan83912063messa_n
messans92710463messans
messily12298813messily
messy104913833mess__y
missay114112143missa_y
necessary1452313necessary
nectary1246223nectary
ossuary1043943ossuary
palmary14338553palmary
passably1537253passably
passade1039233passade
passado1037053passado
passage1039803passage
passant9813943passant
passer84721033passer_
passerby1542503passerby
passers94717753passers
passkey1633563passkey
pastry114913033p_astry
peaky145718153pe__aky
pear69745233pe__ar_
pearl75324463pe__arl
pearly116414843pe__arly
pears75138613pe__ars
peart76440753pe__art
peasant9314923peasant
peasantry1442883peasantry
peaty105725693pe__aty
peavy135014843pe__avy
pedlar93311273pedlar_
pedlars103210213pedlars
pedlery13297083pedlery
peery105719443pe__ery
peltry11288653pe_ltry
penury1148103pe_nury
peppery13286253peppery
perisarc1245363perisarc
perjury19244253perjury
perry105222713pe__rry
persalt9315413persalt
perspiry1543783perspiry
pesade9311103pe_sade
peskily1635083peskily
pesky145911563pe_s_ky
pessaries11108663pessaries
pester84827593pester_
pesters93827093pesters
pesty106421713pe_s_ty
petard95013803pe_tard
petsai838083petsa_i
petsais938433petsais
pissant91012503pissant
pisser84416383pisser_
pissers95014753pissers
plenary1237543plenary
plessor9317693plessor_
plessors10278253plessors
presser93717623presser_
pressers103215023pressers
pressmark1762843pressmark
pressor93512883pressor_
pressors103212693pressors
pressure1039773pressure
primary1437703primary
pulsar8329363pulsar_
pulsars9358913pulsars
pussley12375123pussley
pussly11407373puss_ly
pussy105614843puss__y
resay85320543re_sa_y
respray1236503respray
restart7320033restart
retiary1038333retiary
rosary92810353_rosary
sassaby1244003sassaby
scary105222593__scary
sectary1238273sectary
senary93716073se_nary
sensory10329093sensory
spermary1545043spermary
teary85124053te__ary
ternary1038343ternary
tessera736333tessera
testacy1235963testacy
tussar6369543tussar_
tussars7359253tussars
vespiary1642743vespiary
vestiary1444313vestiary
vestry1238623ve_stry
weary115620613we__ary
wessand1144833wessand
zedoary2043213zedoary

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.423422437.4
2DLD Change Limit1340271296.89019452.4
3Display Results1291290.0462804.3
 (SQL Overall)1786911297.35924282.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.