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

167 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
valances139876(None) 
balances1279971balances
valance1269251valance_
valanced1475461valanced
valences1388511valences
valiances1487201valiances
avalanches18102842avalanches
balance11510262balance_
balanced1356512balanced
balancer1246602balancer
balancers1345062balancers
glances104113142_glances
lances84824102__lances
palaces114216452pala_ces
parlances1348952parlances
vacancies1645492vacancies
valence1268772valence_
valencies1446412valencies
valiance1397382valiance_
valiancies1545282valiancies
valines104520212valin_es
variances14117362variances
adamances1445033adamances
advances1445613advances
alands75418373_alan_ds
alane56135613_alan_e_
alanines8314803_alanines
alanins7315803_alanins
alans55636173_alan__s
alants67722023_alan_ts
alanyls1084353_alanyls
alates64833963_ala_tes
alines65735223_alin_es
alkanes113812933_alkan_es
alliances11107093alliances
almuces11316823_almuces
anankes1138763_anankes
anlaces92313733anla_ces
atlantes838553atlantes
avalanche17112513avalanche
avalanched19121713avalanched
balases93815433bala_ses
bivalences17104343bivalences
blanches153311603_blanches
cadences1338473cadences
calashes13310533calashes
calces104420053cal__ces
calices114321693cal_ices
calyces14428803cal_yces
chances145218093_chances
covalences1745833covalences
dalliances1344263dalliances
dances95120653__dances
divalences16114773divalences
durances1158683durances
enhances1339293enhances
enlaces92313393enla_ces
faiences1337043faiences
falces115216003fal__ces
feasances1445403feasances
fiances12310673_fiances
finances1338653finances
flanes94522423_flan_es
flanges113413273_flanges
galangas1046173galangas
galaxes1538873gala_xes
galaxies1637163galaxies
glaces94218023_gla_ces
glance94312313_glance_
glanced11439233_glanced
glancer103710073_glancer
glancers11408003_glancers
glandes95413833_glandes
halluces1335613halluces
hances115621283__hances
imbalances1643673imbalances
inlaces92512903inla_ces
jaunces16307423ja_unces
joyances2044413joyances
kalanchoes1951843kalanchoes
laces76141763__la_ces
laitances1145613laitances
lance75126723__lance_
lanced93717723__lanced
lancer84319973__lancer
lancers93616643__lancers
lancet84223573__lancet
lancets93411163__lancets
lanes54946793__lan_es
launces9329003la_unces
malaccas1445163malaccas
maladies11311933maladies
malaises10312333malaises
malanders1237023malanders
malangas1136863malangas
malates93522603mala_tes
malices114316623mal_ices
malines93625603malin_es
melanges1138613melanges
nances83618643__nances
nuances938523_nuances
palace104516913pala_ce_
palaced124110773pala_ced
palates93624933pala_tes
parlance1248723parlance_
pavanes123612653pavan_es
penances12312443penances
phalanges1565363phalanges
phalanxes2153913phalanxes
places104323703_pla_ces
plaices11411143_plaices
planches153111863_planches
planes85028083_plan_es
prances113618773_prances
radiances1247693radiances
rances84625443__rances
ratanies8312923ratanies
rebalances1445253rebalances
relaces93420883rela_ces
reliances1139623reliances
romances12310793romances
salaries8319573salaries
saliences11108063saliences
salines74029413salin_es
seances93015343_seances
silanes72517163silan_es
silences10310073silences
solaces93116133sola_ces
sonances10310263sonances
stances93715963_stances
tolanes74216313tolan_es
trances93919643_trances
unbalances1443513unbalances
unlaces92513623unla_ces
usances967373_usances
vacancy1744443vacanc_y
vacates12312833vaca_tes
vagaries12310293vagaries
vagrancies1644173vagrancies
vahines133410523vahin_es
valancing1544743valancing
valencia1343763valencia
valencias1443633valencias
valency1565463valenc_y
vales85434263val___es
valguses1234233valguses
valiancy1674813valianc_y
valiants1137793valian_ts
valine94623093valin_e_
valises103516263val_ises
valonias1147473valonias
valses94514613val__ses
valuables1442973valuables
valuates112811203valuates
values94314943val__ues
valves124113783val__ves
valvules1443473valvules
vanes85130973v__an_es
variance1397413variance_
varices123313573va_rices
vibrances1645763vibrances
vigilances1643533vigilances
violences1445493violences
vivaces1536413viva_ces
voidances1544473voidances
volante1038513volante_
volcanoes1443783volcanoes

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.423422437.4
2DLD Change Limit1461621676.51322441.6
3Display Results1671670.0632650.8
 (SQL Overall)1786911676.99925530.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.