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

96 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
askance134592(None) 
advance1346042advance
alkane104313322alkan_e
askant10412712askan_t
seance83716682_seance
stance84316912_stance
usance858012us_ance
abeyance1545003abeyance
abidance1346323abidance
absence1137703absence
acutance1246303acutance
adamance1345543adamance
advanced1543313advanced
advancer1443483advancer
advances1445613advances
affiance1645653affiance
akene95818663a_ken_e
alane56135613a_lan_e
alkanes113812933alkanes
alkanet113714433alkanet
alkene104114003alken_e
alkine104916803alkin_e
alkyne13436863alkyn_e
alliance1097263alliance
ambiance1446063ambiance
ananke1038283a_nanke
andante8311273andante
anlace82513923anla_ce
apace94718383a_pa_ce
arcane81216743arcan_e
arrange838683arrange
asana5315483as_an_a
asanas6514113as_anas
asking116017233askin_g
askings12519173askings
aslant6317753aslan_t
assonance1144443assonance
assurance1145283assurance
balance11510263balance
chance134617093_chance
dance85223133__dance
distance11311853distance
durance1059113durance
enhance1239693enhance
essence947673essence
feasance1345823feas_ance
fiance11310743_fiance
finance1238573finance
glance94312313_glance
hance105424153__hance
instance1049873instance
issuance1045213issuance
joyance1944773joyance
kane85133973__kan_e
kokanee1044803kokanee
laitance1045973laitance
lance75126723__lance
maskable1638003maskable
naissance1143443naissance
nance74721843__nance
nascence1256183nascence
nuance859043_nuance
parlance1248723parlance
penance11313443penance
prance104318573_prance
radiance1148123radiance
rance75028513__rance
romance11311083romance
saice75424053_s_aice
sane45954343_s_an_e
sauce75121653_s_auce
scarce104013633_scarce
sconce104711723_sconce
seances93015343_seances
since75024173_s_ince
skank84415583_skan_k
skanked11338103_skanked
skanker10268483_skanker
skanks94710833_skanks
skanky12476963_skanky
skate94721553_ska_te
skeane104611373_skean_e
skene96118123_sken_e
sonance9310313sonance
space95325673_spa_ce
spancel1147363_spancel
spence103813793_spence
stances93715963_stances
stanch113812373_stanch
stane55933003_stan_e
trance84718763_trance
usances967373us_ances
usaunce9103383usaunce
valance1269253valance
valiance1397383valiance
variance1397413variance

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.406440125.6
2DLD Change Limit134027965.89022755.0
3Display Results96960.0332909.1
 (SQL Overall)178691966.32928233.7
 
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.