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

127 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
espalier103636(None) 
espaliers1144121espaliers
empaler11288352empal_er
espaliered1341972espaliered
palier85023562__palier
scalier94316912_scalier
shalier103116422_shalier
spacier114011632_spacier
spaller92713472_spaller
applier1137903_applier
assailer844823assailer
bespatter1343143bespatter
cavalier1348173cavalier
coalier93416183_coalier
desalter938363des_alter
despair1045463despa_i_r
despairer1243693despairer
despoiler1243963despoiler
earlier72612743e_arlier
easier64218463e__asier
eelier64216463e__elier
embalmer1444063embalmer
empale102611263empal_e_
empaled12288953empal_ed
empalers12226743empal_ers
empales112411433empal_es
empaling1338363empaling
emptier1187603emp_tier
entailer877833entailer
equaliser1854483equaliser
equalizer2745753equalizer
escalader1243233escalader
escaper11368843esca_per
espaliering1442693espaliering
espied9359773esp__ied
espies83716803esp__ies
espouser1044383espouser
essayer1033943essa_yer
exalter1437563e_xalter
expander18145803expander
expeller17105783expeller
explainer1844243explainer
gasalier936443gasalier
impaler11298393impal_er
lavalier1146043lavalier
mealier93015903_mealier
pacier105018683__pacier
paler75436933__pal_er
pallier94417163__pallier
palmer105816543__palmer
palmier113312173__palmier
palter84423263__palter
panier84425503__panier
pedalier1137603pedalier
plier75221283__p_lier
psalter9247813ps_alter
replier94214973rep_lier
ripplier1234463ripplier
sagier73717163_s_agier
sailer63526103_s_ailer
sallier73320423_sallier
salter64325083_s_alter
saltier74318633_s_altier
salver94617753_s_alver
sappier113613113_sappier
scaler84321603_scal_er
scalper113912923_scalper
scarier94017873_scarier
sealer63928963_seal_er
seamier93114633_seamier
seemlier1035193seemlier
sepaled10510593sepal_ed
sepaline10311343sepaline
sepalled1156903sepalled
shadier113111153_shadier
shakier143411153_shakier
shoalier1137073shoalier
sillier74017593_sillier
slatier74016813_slatier
slier54827243_s__lier
smaller93410333_smaller
snakier112810003_snakier
snarlier8278183_snarlier
soapier93411713_soapier
spacer104917793_spa_cer
spader94317133_spa_der
spale74929213_spal_e_
spales84728103_spal_es
spalled103113133_spalled
spallers102910733_spallers
spammer133410433_spammer
spanglier1244193_spanglier
spaniel948923_spaniel
spanker133612353_spanker
spanner94312563_spanner
sparer84524963_spa_rer
sparger103613083_sparger
sparker133914363_sparker
sparkier14298033_sparkier
sparklier1554363_sparklier
sparrier10329143_sparrier
sparser94311483_sparser
spatter94016523_spatter
spavie113611383_spavie_
spavies123012943_spavies
spaviet123011923_spaviet
spawner12347363_spawner
speller95415143_speller
spelter94113703_spelter
spicier115112463_spicier
spier75728033_sp__ier
spikier13369983_spikier
spiller92914333_spiller
spinier93715163_spinier
spirier93214073_spirier
splicer114710523_sp_licer
spoiler93310683_spoiler
sprawlier1443293_sprawlier
sprier84119063_sp_rier
spumier1137903_spumier
stagier83513443_stagier
staler64025823_stal_er
stalker113912253_stalker
stalkier1257073_stalkier
supplier1246603supplier
surlier72915443_surlier
vealier102712173_vealier

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.423422437.4
2DLD Change Limit1461621277.67019056.3
3Display Results1271270.0462760.9
 (SQL Overall)1786911278.13921954.9
 
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.