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

115 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
posturers113705(None) 
pasturers1136391pasturers
posturer1038921posturer_
postures10313781posture_s
costumers1374852costumers
fosterers12238022fosterers
gesturers1044282gesturers
pasturer1037522pasturer_
pastures10311962pasture_s
pesterers112510452pesterers
posters93928012post__ers
posture9313252posture__
postured1139492posture_d
potterers11218662potterers
pourers93513672po__urers
torturers944342torturers
assurers866313_assurers
bolsterers1244683bolsterers
capturers1344633capturers
colourers1136473colourers
conjurers18126233conjurers
construers1245873construers
costers94128333cost__ers
costrels1038933cost_rels
costumer1275103costumer_
costumery1663113costumery
costumes1258013costume_s
costumiers1442973costumiers
coutures10311993couture_s
couturiers1243853couturiers
disturbers13164163disturbers
ensurers8279373ens_urers
fosterer11239523fosterer_
fosters104220103fost__ers
gesturer935983gesturer_
gestures9310013gesture_s
honourers1245573honourers
hostelers1246633hostelers
hostlers113310483host_lers
impostures1443803imposture_s
insurers83710133ins_urers
jostlers15357683jost_lers
lecturers11124233lecturers
lobsterers1243483lobsterers
loiterers936263loiterers
maturers1037373_maturers
moistures1147323moisture_s
nurturers943353nurturers
ostlers72911203_ost_lers
oysterers1245573oysterers
palterers11249533palterers
pasters94531733past__ers
pasture9311463pasture__
pastured1138233pasture_d
patterers112410123patterers
perjurers18224463perjurers
perturbers1442633perturbers
pesterer102412703pesterer_
pesters93827093pest__ers
pewterers14216043pewterers
pictures1249343picture_s
plasterers1286123plasterers
poetisers1145303poetisers
poetizers2045103poetizers
poitrels1035243poit_rels
polluters1135033polluters
ponderers12248453ponderers
porteress1137933porteress
porters93722703port__ers
portress1038323port_ress
posers84223973pos___ers
poseurs9378293poseu__rs
postages112815323postage_s
postarrest1244643postarrest
posteens10309733post_eens
poster84129173post__er_
posteriors1256813posteriors
postern93615613post__ern
posterns102713723poster_ns
postgrads1344873postgrads
posties93128813post_ie_s
postludes1244623postlude_s
postponers1445273postponers
postriders1344853postriders
postteens1144373postteens
postural1049203postur_al
posturing1238993posturing
posturist11410443posturist
posturists1247073posturists
pothers123818623po_t_hers
potterer102310263potterer_
potters94024343po_t_ters
potzers184010543po_t_zers
poulterers1244563poulterers
pourer84516043po__urer_
pouters94221873po__uters
powderers15214793powderers
powters124015663powt__ers
procurers1345033procurers
pustules1038443pustule_s
putterers11238363putterers
restorers95110113restorers
roisterers1045113roisterers
rosters73727543rost__ers
roturiers944553ro_turiers
starers74522313__starers
storers75018683__storers
torturer835493torturer_
tortures838913torture_s
totterers9186813totterers
tourers73512743to__urers
usurers766363_us_urers
venturers1245523venturers
vestures11311043vesture_s
zosters163015413zost__ers

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 Filter1786911486410.1601116818.8
2DLD Change Limit1486411157.18620684.8
3Display Results1151150.0462500.0
 (SQL Overall)1786911157.39224173.6
 
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.