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

54 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
poulterers124456(None) 
poulterer1145421poulterer_
adulterers1143172adulterers
boulderers1343662boulderers
palterers11249542p_alterers
potterers11218662po_tterers
poulters103911052poult__ers
putterers11238362p_utterers
adulterer1043553adulterer_
adulteress1142903adulteress
alterers82512503__alterers
blusterers12174993blusterers
bolsterers1244683bolsterers
boulderer1244403boulderer_
coulters103614313coult__ers
falterers12238043_falterers
filterers12206973_filterers
flutterers13184593flutterers
fosterers12238023fo_sterers
fruiterers1343003fruiterers
lobsterers1243483lobsterers
loiterers936263lo_iterers
moulters103510783moult__ers
mutterers11247373_mutterers
oysterers1245573_oysterers
palterer102411293p_alterer_
patterers112410133p_atterers
pesterers112510463p_esterers
pewterers14216043p_ewterers
pilferers1444583p_ilferers
plasterers1286123plasterers
plunderers1343333plunderers
polltakers1642403polltakers
ponderers12248453po_nderers
porteress1137933po_rteress
posturers1137053po_sturers
potterer102310263po_tterer_
poulter93712013poult__er_
poultices1345673poultice_s
poultries1148453poult_ries
pourers93513673pou___rers
pouters94221873pou_t__ers
powderers15214793po_wderers
puckerers1744513p_uckerers
putterer10209913p_utterer_
roisterers1045123roisterers
saunterers1044383saunterers
shelterers1344343shelterers
solderers1066533so_lderers
splutterers13142163splutterers
sputterers12174583sputterers
stutterers10164303stutterers
totterers9186813to_tterers
utterers8218653__utterers

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.423422437.4
2DLD Change Limit140603545.59325139.1
3Display Results54540.0134153.8
 (SQL Overall)178691546.02929638.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.