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

168 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
fosterer1123952(None) 
fostered122210451fostered
fosterers12238021fosterers
austerer838382austerer
bolsterer1145482bolsterer
falterer11239852falterer
fastener11227832fastener
festered122512102festered
fetterer11207812fetterer
filterer11258142filterer
foster94322222fost__er
fosters104220102foster_s
hosteler1137272hosteler
lobsterer1144032lobsterer
loiterer837082loiterer
oysterer1136102oysterer
pesterer102412702pesterer
posturer1038922posturer
potterer102310262potterer
roisterer946432roisterer
totterer8217792totterer
alterer72713993_alterer
answerer1144273answerer
austere7312993austere_
banterer102811773banterer
barterer102711633barterer
batterer102713213batterer
bistered112913323bistered
bitterer10309773bitterer
blusterer11176293blusterer
bolstered1246093bolstered
bolsterers1244683bolsterers
borderer1168103borderer
caterer92815943_caterer
coherer122912783co_herer
coshered14610293coshered
coster84331293cost__er
costers94128333coster_s
costlier1038523costlier
costrel9310373cost_rel
costumer1275103costumer
cottered112511733cottered
coverer123113523co_verer
dodderer1144203dodderer
dosseret91111513dosseret
dotterel945063dotterel
easterner945053easterner
enterer72015633_enterer
faltered122810983faltered
falterers12238033falterers
fastened12257853fastened
fasteners12237053fasteners
faster94625773fast__er
fattener11268113fattener
fester94723513fest__er
festers104121393fester_s
fettered12259493fettered
fetterers12267043fetterers
filtered12259043filtered
filterers12206973filterers
fingerer12127223fingerer
flatterer12187673flatterer
flowerer1435453flowerer
flustered13185883flustered
flutterer12185263flutterer
foddered1434553foddered
footer94320773foot__er
footers104618333footer_s
footier104115113foot_ier
footler104011873foot_ler
forbearer1444513forbearer
forever1338953fo_rever
fosterage1344663fosterage
fosterages1444773fosterages
fostering132411263fostering
fritterer12234403fritterer
frostier1148163frost_ier
fruiterer1243333fruiterer
furtherer1543813furtherer
fustier104213933fust_ier
gesturer935983gesturer
gospeler1173963gospeler
hastener11259133hastener
holstered1345883holstered
hosteled1237283hosteled
hostelers1246633hostelers
hosteller1245833hosteller
hostler103411023host_ler
hoverer13319823ho_verer
jostler14288223jost_ler
koshered1636063koshered
letterer8259223letterer
listener8158313listener
litterer82810173litterer
lobstered1244643lobstered
lobsterers1243483lobsterers
loitered938183loitered
loiterers936263loiterers
lustered92510603lustered
mastered112614003mastered
miterer92511333_miterer
moistener1145843moistener
mustered112511503mustered
mutterer10218913mutterer
offerer1335543_offerer
oftener1035923_oftener
orderer8127943_orderer
osiered837123_osiered
ostler63312193_ost_ler
oystered1236923oystered
oysterers1245573oysterers
palterer102411273palterer
pasturer1037523pasturer
patterer103112173patterer
pestered112814963pestered
pesterers112510453pesterers
pewterer13256313pewterer
plasterer1178103plasterer
ponderer112410193ponderer
portered112311543portered
posteen93512623poste_en
poster84129173post__er
posterior1147833posterior
postern93615613poster_n
posterns102713723posterns
posters93928013poster_s
posture9313253posture_
postured1139493postured
posturers1137053posturers
postures10313783postures
pottered112311663pottered
potterers11218663potterers
poulterer1145423poulterer
powderer14245593powderer
putterer10209913putterer
restorer84813723restorer
roistered1037643roistered
roisterers1045113roisterers
roster64329083rost__er
rosters73727543roster_s
rottener8216973rottener
roystered1344873roystered
serer55935513__s_erer
sistered92612803sistered
soberer93110353so_berer
softener1145613softener
solderer947183solderer
sorcerer1036433sorcerer
starer64027363__starer
steer55423863__ste_er
steerer73113633__steerer
stere55328543__stere_
stereo65317913__stereo
steres63929533__steres
sterner7411913__sterner
storer64721673__storer
titterer8268523titterer
torturer835493torturer
tottered9208703tottered
totterers9186813totterers
utterer71910463_utterer
waterer103314073_waterer
westered122511863westered
westerner1244953westerner
winterer112110443winterer
wonderer12249183wonderer
zoster153715853zost__er
zosters163015413zoster_s

Search took 9 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.453394461.4
2DLD Change Limit1461621688.39317414.8
3Display Results1681680.0762210.5
 (SQL Overall)1786911688.92220028.1
 
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.