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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

120 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
fosterers1223802(None) 
fosterer11239521fosterer_
bolsterers1244682bolsterers
falterers12238032falterers
fasteners12237052fasteners
fetterers12267042fetterers
filterers12206972filterers
fostered122210452fostere_d
fosters104220102fost__ers
hostelers1246642hostelers
lobsterers1243482lobsterers
loiterers936262loiterers
oysterers1245572oysterers
pesterers112510462pesterers
posturers1137052posturers
potterers11218662potterers
roisterers1045112roisterers
totterers9186812totterers
alterers82512493_alterers
answerers1243743answerers
austerer838383austerer_
banterers112410003banterers
barterers11269633barterers
batterers113110713batterers
blusterers12174993blusterers
bolsterer1145483bolsterer_
borderers1276333borderers
caterers102814403_caterers
coherers132310733co_herers
costers94128333cost__ers
costrels1038933cost_rels
costumers1374853costumers
coverers132712123co_verers
dodderers1243803dodderers
dosserets10145693dosserets
dotterels1043903dotterels
easterners1044823easterners
enterers82214153_enterers
falterer11239853falterer_
fastener11227833fastener_
fatteners12236873fatteners
festered122512113festere_d
festers104121393fest__ers
fetterer11207813fetterer_
filterer11258143filterer_
fingerers13136303fingerers
flatterers13175913flatterers
flowerers1544503flowerers
flutterers13184593flutterers
footers104618333foot__ers
footlers113910793foot_lers
forbearers1543673forbearers
forevers1438173fo_revers
fortress1136753fort_ress
foster94322223fost__er_
fosterage1344663fosterage
fosterages1444773fosterages
fostering132411263fostering
fritterers13203393fritterers
fruiterers1343003fruiterers
furtherers1643323furtherers
gesturers1044283gesturers
gospelers1273683gospelers
hasteners12267813hasteners
hosteler1137283hosteler_
hostellers1344683hostellers
hostlers113310483host_lers
hoverers14289023ho_verers
jostlers15357683jost_lers
letterers9228113letterers
listeners9147323listeners
litterers9228193litterers
lobsterer1144033lobsterer_
loiterer837083loiterer_
miterers10219683_miterers
moisteners1244783moisteners
mutterers11247373mutterers
offerers1434933_offerers
orderers9116563_orderers
ostlers72911203_ost_lers
oysterer1136103oysterer_
palterers11249533palterers
pasturers1136393pasturers
patterers112410123patterers
pesterer102412713pesterer_
pewterers14216043pewterers
plasterers1286123plasterers
ponderers12248453ponderers
porteress1137933porteress
posteens10309733poste_ens
posteriors1256813posteriors
posterns102713723poster_ns
posters93928013post__ers
posturer1038923posturer_
postures10313783posture_s
potterer102310263potterer_
poulterers1244563poulterers
powderers15214793powderers
putterers11238363putterers
restorers95110113restorers
roisterer946433roisterer_
rosters73727543rost__ers
softeners1245133softeners
solderers1066533solderers
sorcerers1145323sorcerers
starers74522313__starers
steerers82511353__steerers
steers63820983__ste_ers
stereos74314973__stereos
steres63929533__stere_s
storers75018683__storers
titterers9236993titterers
torturers944343torturers
totterer8217793totterer_
utterers8218653_utterers
waterers112312783_waterers
westerners1344473westerners
winterers12209723winterers
wonderers13217933wonderers
zosters163015413zost__ers

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.453394461.4
2DLD Change Limit1486411206.42323142.0
3Display Results1201200.0602000.0
 (SQL Overall)1786911206.93625762.8
 
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.