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

104 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
poitrels103524(None) 
poitrel936191poitrel_
coistrels1145262coistrels
costrels1038932costrels
dottrels963492dottrels
goitres8389562goitre_s
petrels9279372p_etrels
peytrels1363372peytrels
portress1038322portress
boatels93510233boat_els
boites84322703boit_e_s
botels84815803bo_t_els
citrals91111673_citrals
coistrel1046743coistrel_
coistrils1146423coistrils
controls10311393controls
costrel9310373costrel_
doggrels1142633doggrels
dottels8327783do_ttels
dotterels1043903dotterels
dottrel834463dottrel_
editress944933editress
fortress1136753fortress
goiters84014443goit_ers
goitre7349003goitre__
goitrous945763goitrous
gomerels1144563gomerels
hostels103712313host_els
hotels94515513ho_t_els
jointress1643053jointress
kestrels1235813kestrels
litres65220393_litre_s
loiterers936263loiterers
loiters74116613loit_ers
mitres83922073_mitre_s
moires8915633moi_re_s
mongrels1135333mongrels
morels84820013mo__rels
motels83616893mo_t_els
nitres65519333_nitre_s
nitrils72810703_nitrils
nostrils848183nostrils
parrels94713493p_arrels
pastels95215183past_els
patrols93513513p_atrols
petrel83111533p_etrel_
petrols92913083p_etrols
peytrals1355493peytrals
peytrel1264253peytrel_
philtres1396513philtre_s
pipistrels1451503pipistrels
pitiers93812653p_itiers
pities83828083p_itie_s
pixels15478533p_i_xels
podites103014733podit_e_s
poetess938933poet_ess
poetless1038723poetless
poetries10315583poetries
pointers103013723pointers
pointes93216753pointe_s
pointless1135703pointless
poisers94214433poi_sers
poises84226543poi_se_s
politely1347093polit_ely
polities102722343politie_s
pomfrets1543033pomfrets
pommels13235783po_mmels
pontes83627853pont_e_s
pontils9312213pont_ils
pores75849033po__re_s
portals94015563port_als
porteress1137933porteress
porters93722703port_ers
portless10310643portless
portrays1345293portrays
positrons1186543positrons
postals93716373post_als
posteens10309733posteens
posterns102713723posterns
posters93928013post_ers
posties93128813postie_s
posturers1137053posturers
postures10313783posture_s
poteens92910883po_teens
potfuls1236293po_tfuls
pothers123818623po_thers
potteens10256793potteens
potterers11218663potterers
potters94024343po_tters
potties93723543pottie_s
pottles93816983pottle_s
potzers184010543po_tzers
pourers93513673po_urers
pouters94221873pout_ers
powters124015663powt_ers
pretzels1934033pretzels
prioress1035393prioress
soirees72411643soi_rees
sorels63921163so__rels
sorrels7310723so_rrels
titres64718933_titre_s
votress1035483vo_tress
waitress1135223waitress
wastrels1136203wastrels

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 Limit1461621046.76621602.4
3Display Results1041040.0303466.7
 (SQL Overall)1786911047.21624763.2
 
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.