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

80 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
pilferer134492(None) 
pilfered1435851pilfered
pilferers1444581pilferers
filterer11258142filterer
palterer102411272palterer
pilfer1139162pilf__er
pilfers1238962pilfer_s
pilsener1044752pilsener
silverer11216732silverer
alterer72713993_alterer
bickerer16106773bickerer
billeter1037563billeter
bitterer10309773bitterer
cipherer1545573cipherer
differed1635523differed
ditherer12187763ditherer
falterer11239853falterer
filtered12259043filtered
filterers12206973filterers
fingerer12127223fingerer
hinderer1238273hinderer
inferrer11217443_inferrer
kipperer16294723kipperer
limberer12187053limberer
lingerer9118303lingerer
litterer82810173litterer
miterer92511333mi_terer
niffered1544143niffered
offerer1335543_offerer
palaverer1443163palaverer
palfrey1533343palf_rey
paltered113012483paltered
palterers11249533palterers
pamperer14228333pamperer
panderer112210913panderer
paperer113111903p_aperer
patterer103112173patterer
peltered112510453peltered
pepperer1145283pepperer
pesterer102412703pesterer
pewterer13256313pewterer
philtered1545493philtered
piaffer15104443piaf_fer
pickeer153710113picke_er
pickerel1645273pickerel
picketer16187433picketer
piecer105213083pi__ecer
piercer11337773pi__ercer
pilaster1038163pilaster
pilferage1542603pilferage
pilferages1642623pilferages
pilfering1536393pilfering
pillager11278553pillager
pillared11228093pillared
pilseners1144943pilseners
pilsner935343pil_sner
pioneer936893pione_er
ponderer112410193ponderer
potterer102310263potterer
poulterer1145423poulterer
powderer14245593powderer
preferrer1443893preferrer
profferer1742933profferer
properer1259203properer
puckerer1645793puckerer
putterer10209913putterer
silvered12237563silvered
silverers12215753silverers
simperer1237173simperer
sincerer1037203sincerer
sliverer11237633sliverer
solderer947183solderer
sufferer1436063sufferer
telfered1234883telfered
tillered937443tillered
tinkerer1286803tinkerer
titterer8268523titterer
wildered1336633wildered
winterer112110443winterer
witherer14187953witherer

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 Filter1786911461620.420425454.8
2DLD Change Limit146162807.23620199.3
3Display Results80800.0302666.7
 (SQL Overall)178691807.68623248.9
 
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.