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

74 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
espaliers114412(None) 
espalier1036361espalier_
empalers12226742empal_ers
espaliered1341972espaliered
spallers102910732_spallers
appliers1235573_appliers
assailers943983assailers
bespatters1442783bespatters
cavaliers1455623cavaliers
desalters1037673des_alters
despairers1343103despairers
despairs1144943despa_i_rs
despoilers1343533despoilers
embalmers1543773embalmers
empaler11288353empal_er_
empales112411433empal_e_s
emptiers1275193emp_tiers
entailers976413entailers
equalisers1942943equalisers
equalizers2843983equalizers
escaladers1342513escaladers
escapers12337413esca_pers
espaliering1442693espaliering
espies83716803esp__ie_s
espousers1143383espousers
essayers1133563essa_yers
exalters1536653e_xalters
expanders19125093expanders
expellers18104753expellers
explainers1943113explainers
gasaliers1044513gasaliers
impalers12226973impal_ers
lavaliers1254283lavaliers
palier85023563__palier_
palmers113513623__palmers
palters94021683__palters
paniers94717333__paniers
pedaliers1245183pedaliers
pliers84715153__p_liers
psalters10227713ps_alters
repliers103710163rep_liers
sailers73822323_s_ailers
salliers83613343_salliers
salters73622253_s_alters
saltiers83411953_s_altiers
salvers103916003_s_alvers
scalers93817263_scal_ers
scalier94316913_scalier_
scalpers123710863_scalpers
sealers74323553_seal_ers
shalier103116423_shalier_
spacers113813873_spa_cers
spacier114011633_spacier_
spaders104214473_spa_ders
spales84728103_spal_e_s
spaller92713473_spaller_
spammers14378693_spammers
spaniels1045963_spaniels
spankers14369863_spankers
spanners103710773_spanners
sparers94519613_spa_rers
spargers11389733_spargers
sparkers144111313_sparkers
spatters103914703_spatters
spavies123012953_spavie_s
spawners13396493_spawners
spellers102812763_spellers
spelters103912243_spelters
spiers84421743_sp__iers
spillers103311703_spillers
splicers12338113_sp_licers
spoilers10238633_spoilers
stalkers12369853_stalkers
suppliers1354483suppliers

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 Filter1786911486410.420425454.8
2DLD Change Limit148641747.67319372.0
3Display Results74740.0302466.7
 (SQL Overall)178691748.12321998.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.