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 “pleasures” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

79 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
pleasures114557(None) 
pleasure1045541pleasure_
pleasured1244191pleasured
leisures836682_leisures
measures1038912_measures
pleasers104010292pleaser_s
pleases94515482pleas__es
preassures1245272preassures
pressures1149062pressures
treasures946632treasures
admeasures1352433admeasures
censures102211623_censures
closures10228953cl_osures
creatures1138413creatures
displeasures1551493displeasures
ensures73315903__ensures
erasures837213_erasures
features11310333_features
flexures1843423fle_xures
leaguers935063_leaguers
leagues837943_leagu_es
leasers74717843_leaser_s
leases65428113_leas__es
leashes103514403_leas_hes
lectures101310153_lectures
leisure736693_leisure_
leisured934763_leisured
lemures938793_le_mures
measure939033_measure_
measured1136463_measured
measurer1035953_measurer
measurers1144883_measurers
oleasters936733oleasters
parures9512693p__arures
pastures10311963p__astures
peases85229473p_eas__es
perdures11289683p_erdures
perjures17268083p_erjures
petasuses1144373petasuses
piastres10249303p_iastres
plaguers11286503pl_aguers
plagues103311063pl_agu_es
plaques18317893pl_aqu_es
plashers133813453pl_ashers
plashes124417393pl_as_hes
plasters103518133pl_asters
pleaches153210433plea_ches
pleaders113210183pleader_s
pleasances1444193pleasances
please84315733pleas__e_
pleased103712073pleas__ed
pleaser93912343pleas__er
pleasureless1451213pleasureless
pleasuring1343503pleasuring
pleaters103613793pleater_s
pleathers1446453pleathers
plessors10278253plessor_s
pleuras937413ple__uras
plexuses1734113ple_xuses
plicatures1443983plicatures
preassure1145623preassure_
preassured1344533preassured
precures12312903pre_cures
prelatures1245723prelatures
prematures1447053prematures
premeasures1552823premeasures
pressure1039773pressure_
pressured1237333pressured
presumes1239843pre_sumes
rasures7312013__rasures
reassures937223_reassures
remeasures1243853remeasures
seisures838273_seisures
treasure846753treasure_
treasured1044983treasured
treasurer944253treasurer
treasurers1043203treasurers
treasuries1045543treasuries
tressures946293tressures

Search took 9 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 Filter1786911486410.440406115.9
2DLD Change Limit148641797.68619339.2
3Display Results79790.0302633.3
 (SQL Overall)178691798.15621909.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.