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

163 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
valance126925(None) 
balance11510261balance
valanced1475461valanced
valances1398761valances
valence1268771valence
valiance1397381valiance
alane56135612_alan_e
avalanche17112512avalanche
balanced1356512balanced
balancer1246602balancer
balances1279972balances
glance94312312_glance
lance75126722__lance
palace104516912pala_ce
parlance1248722parlance
vacancy1744442vacancy
valences1388512valences
valency1565462valency
valiances1487202valiances
valiancy1674812valiancy
valine94623092valin_e
variance1397412variance
volante1038512volante
adamance1345543adamance
advance1346043advance
alack114820063_ala_ck
alae45643753_ala__e
alan46844083_alan__
aland65526413_alan_d
alands75418373_alands
alang66023513_alan_g
alanin6317273_alanin
alanine7316863_alanine
alans55636173_alan_s
alant55742293_alan_t
alants67722023_alants
alanyl955483_alanyl
alate55340323_ala_te
aline57243153_alin_e
alkane104313323_alkan_e
alliance1097263alliance
almuce10348213_almuce
alone55732963_alon_e
ananke1038283_ananke
anlace82513923anla_ce
apace94718383_apa_ce
askance1345923askance
avalanched19121713avalanched
avalanches18102843avalanches
balancers1345063balancers
bivalence16124603bivalence
blanch133410853_blanch
cadence1239063cadence
calando1037383calando
chance134617093_chance
covalence1645843covalence
dalliance1244203dalliance
dance85223133__dance
divalence15135093divalence
durance1059113durance
enhance1239693enhance
enlace82213233enla_ce
faience1237513faience
feasance1345823feasance
fiance11310743_fiance
finance1238573finance
flange103411973_flange
galanga936013galanga
glace87420153_gla_ce
glanced11439233_glanced
glancer103710073_glancer
glances104113143_glances
hance105424153__hance
imbalance1543933imbalance
inlace82513043inla_ce
jaunce15367433ja_unce
joyance1944773joyance
kalanchoe1851853kalanchoe
lace66848473__la_ce
laitance1045973laitance
lanced93717723__lanced
lancer84319973__lancer
lances84824103__lances
lancet84223573__lancet
lane45153333__lan_e
launce8469183la_unce
malacca1344953malacca
malaise9312673malaise
malanga1036663malanga
malate84624553mala_te
malice104818483mal_ice
maline84529083malin_e
melange1038363melange
nance74721843__nance
nuance859043_nuance
palaced124110773pala_ced
palaces114216453pala_ces
palate84226783pala_te
parlances1348953parlances
parlante1039693parlante
pavane114113443pavan_e
penance11313443penance
phalange1465193phalange
place94824613_pla_ce
plaice10311553_plaice
planch133711443_planch
planche14299753_planche
plane74929143_plan_e
prance104318573_prance
radiance1148123radiance
rance75028513__rance
rebalance1345763rebalance
relace83122153rela_ce
reliance10310473reliance
romance11311083romance
salable91415463salable
salience10117903salience
saline65132703salin_e
seance83716693_seance
silane62718053silan_e
silence9310213silence
solace83415823sola_ce
sonance9310313sonance
stance84316913_stance
tolane64316583tolan_e
trance84718763_trance
unbalance1344023unbalance
unlace82215173unla_ce
usance858013_usance
vacancies1645493vacancies
vacant11415133vacan_t
vacate11314553vaca_te
vaginae11377683vaginae
vagrancy1743453vagrancy
vahine123612113vahin_e
valancing1544743valancing
vale74937343val___e
valencia1343763valencia
valencies1446413valencies
valiancies1545283valiancies
valiant10314623valian_t
valiants1137793valiants
valines104520213valines
valise92917643val_ise
vallate103016563vallate
valonia1048303valonia
valse85117523val__se
valuable1336863valuable
valuate102512733valuate
value85719093val__ue
valvate133710813valvate
valve114515933val__ve
valvule1343663valvule
vane75534693v__an_e
variances14117363variances
velate93720143vela_te
veloce11310133vel_oce
vibrance1545853vibrance
vigilance1543593vigilance
violence1345713violence
vivace1436553viva_ce
voidance1444723voidance
volant9316323volan_t

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 Filter1786911340270.390458182.1
2DLD Change Limit1340271635.92322628.2
3Display Results1631630.0602716.7
 (SQL Overall)1786911636.37328038.8
 
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.