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

50 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
pustulates127621(None) 
postulates1268961postulates
pustulate1177241pustulate_
pustulated1375541pustulated
postulate1169812postulate_
postulated1377652postulated
pullulates1243922pullulates
pustulants1253422pustulants
pustules1038442pustul__es
ustulate868322_ustulate_
apostolates1354193apostolates
auscultates1352803auscultates
busticates1456613busticates
butylates1444713bu_tylates
cumulates13258973cu_mulates
expostulates2152353expostulates
fistulate1246453fistulate_
fustigates1445143fustigates
gastrulates1253453gastrulates
gratulates1157133gratulates
insulates9311843ins_ulates
jugulates1744603ju_gulates
lustrates939463lust_rates
mutilates11310953mu_tilates
osculates11109393_osculates
pastorates12410143pastorates
pasturages1344923pasturages
peculates132112543p_eculates
populates132710673p_opulates
postdates1248863post_dates
postulants1244963postulants
postulator1246013postulator
postulators1345253postulators
pullulate1144703pullulate_
pullulated1343253pullulated
punctuates1443453punctu_ates
pustulant1145023pustula_nt
pustular1045153pustula__r
pustulating1445243pustulating
pustulation13116623pustulation
pustulations14115623pustulations
pustule937683pustul__e_
pustuled1134953pustul__ed
pustulous1143433pustul_ous
rusticates1248053rusticates
tubulates1147233tu_bulates
ululates848433_u_lulates
undulates1048923_undulates
ungulates1048353_ungulates
upstates10189643upst__ates

Search took 7 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 Filter1786911406030.1561145455.1
2DLD Change Limit140603506.57621381.2
3Display Results50500.0163125.0
 (SQL Overall)178691506.74826480.6
 
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.