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

69 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
poulterer114542(None) 
poulterers1244561poulterers
adulterer1043552adulterer
boulderer1244402boulderer
palterer102411292p_alterer
potterer102310262po_tterer
poulter93712012poult__er
poulters103911052poulter_s
putterer10209912p_utterer
adulterers1143173adulterers
alterer72714013__alterer
austerer838383_austerer
blusterer11176293blusterer
bolsterer1145483bolsterer
bouldered1344483bouldered
boulderers1343663boulderers
coulter94115603coult__er
coulters103614313coulter_s
countered12313003countered
falterer11239873_falterer
filterer11258143_filterer
flutterer12185263flutterer
fosterer11239523fo_sterer
fruiterer1243333fruiterer
lobsterer1144033lobsterer
loiterer837083lo_iterer
mouldered1343753mouldered
moulter93812423moult__er
moulters103510783moulter_s
mutterer10218913_mutterer
oysterer1136103_oysterer
paltered113012503p_altered
palterers11249543p_alterers
patterer103112183p_atterer
peltered112510453p_eltered
pesterer102412713p_esterer
pewterer13256313p_ewterer
philtered1545493philtered
pilferer1344923p_ilferer
plasterer1178113plasterer
plunderer1243763plunderer
polltaker1542723polltaker
ponderer112410193po_nderer
portered112311553po_rtered
posturer1038923po_sturer
pottered112311663po_ttered
potterers11218663po_tterers
poultice1246063poultice_
poulticed1443433poulticed
poultices1345673poultices
poultries1148453poultries
poultry1235383poult_r_y
pourer84516043pou___rer
pouter83923983pou_t__er
pouters94221873pou_ter_s
poutier93215323pou_t_ier
powderer14245593po_wderer
puckerer1645793p_uckerer
puttered112611153p_uttered
putterers11238363p_utterers
roisterer946433roisterer
saunterer945033saunterer
shelterer1245043shelterer
solderer947183so_lderer
splutterer12132743splutterer
sputterer11165263sputterer
stutterer9164913stutterer
totterer8217793to_tterer
utterer71910463__utterer

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 Filter1786911486410.423422437.4
2DLD Change Limit148641696.40623203.4
3Display Results69690.0302300.0
 (SQL Overall)178691696.85926052.0
 
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.