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

75 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
prostyles1415711(None) 
prostyle13187271prostyle_
protyles13249831pro_tyles
urostyles12173971urostyles
peristyles1543862peristyles
prostates11314422prostates
prosties101421192prost_ies
protyle12229452pro_tyle_
protyls12298462pro_tyl_s
restyles1139192_restyles
urostyle11173952urostyle_
apostles1037753apost_les
bristles101510433brist_les
endostyles1452903endostyles
epistyles1454143epistyles
freestyles1642523freestyles
frostless1235743frost_less
frustules1244663frustules
gristles9189203grist_les
hostiles11312213_hostiles
hypostyles2153773hypostyles
jostles143411143_jost_les
misstyles1445023misstyles
nonstyles1245323nonstyles
oldstyles1342233oldstyles
peristyle1444303peristyle_
pestles93217693p_est_les
pistoles102514723p_istoles
posoles9314883p_os_oles
postages112815323p_ostages
postals93716383p_ostal_s
postholes14410453p_ostholes
posties93128813p_ost_ies
postures10313783p_ostures
pottles93816983p_o_ttles
prattles10189403pr_attles
presales10315263pres_ales
presettles1245023presettles
prestiges12310593prestiges
prestores114716083prestores
pretypes15337263pr_etypes
pristanes11410433pristanes
probables1545433probables
proettes10312763proet_tes
profiles133211233pro_files
proles84627203pro___les
proptoses1349873proptoses
propyls14308193pro_pyl_s
proselytes1544743proselytes
proses84733473pros___es
prosodies1249733prosodies
prosses94019513pros__ses
prossies101515223pros_sies
prostate10314533prostate_
prostheses1546553prostheses
prostie91617743prost_ie_
prostrates12411993prostrates
protases102115033pro_tases
proteges1149923pro_teges
protosteles1354563protosteles
prototypes1745923prototypes
protyl11308213pro_tyl__
proustites1246453proustites
pustules1038443p_ustules
restyle1038763_restyle_
restyled1236953_restyled
rootles73215633_root_les
roselles8310713_roselles
rustles73416413_rust_les
styles94418653___styles
throstles1265903throst_les
trestles83012553trest_les
trotyls10236033tro_tyl_s
wrastles11328933wrast_les
wrestles113310063wrest_les

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.420425454.8
2DLD Change Limit148641756.39323250.6
3Display Results75750.0302500.0
 (SQL Overall)178691756.84326113.0
 
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.