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

158 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
sonances1031026(None) 
sonance9310311sonance_
assonances1243912assonances
finances1338652finances
joyances2044412joyances
nances83618642__nances
nondances1247802nondances
penances12312442penances
resonances1246872resonances
romances12310792romances
seances93015342s_eances
solaces93116132sola_ces
sonants7511232sonan_ts
sonnies7315222son_nies
stances93715962s_tances
advances1445613advances
anankes1138763_anankes
assonance1144443assonance_
balances1279973balances
bonacis11310323bona_cis
bonanzas1943113bonanzas
bonnes85621453bon_n_es
boraces113716853bora_ces
boranes93720403boran_es
botanies10312853botanies
bounces113813683bo_unces
buoyances1643353buoyances
chances145218093_chances
cofinances1745303cofinances
conduces13129783conduces
conines93827793conin_es
consonances1545773consonances
convinces1647833convinces
dances95120653__dances
dissonances1454273dissonances
dominances1545683dominances
donates83217223dona_tes
donnees84210363don_nees
durances1158683durances
enhances1339293enhances
enounces1037603enounces
fiances12310673_fiances
finance1238573finance_
financed1435113financed
glances104113143_glances
hances115621283__hances
honans94814503honan__s
inanes62519803_inan_es
ionones7313883ionon_es
issuances1144643issuances
joannes1436243jo_annes
johannes1842943johannes
jounces16369853jo_unces
joyance1944773joyance_
kokanees1143033kokanees
lances84824103__lances
menaces112715523mena_ces
monades103713823mona_des
monarchs1544833monarchs
montanes101114523montan_es
nance74721843__nance_
nancies93516843__nancies
nonages8313843nona_ges
nonces84418833__nonces
nondance1148243nondance_
nondancer1245593nondancer
nondancers1344643nondancers
nuances938523_nuances
oranges84215333_oranges
ordnances1244753ordnances
ounces83617773_o_unces
penance11313443penance_
penanced1338163penanced
pinnaces12268863pinnaces
poignances1543443poignances
pomaces132712123poma_ces
ponces104720843po__nces
portances1349833portances
potences12710693potences
pounces114113893po_unces
prances113618773_prances
rances84625443__rances
resonance1147623resonance_
romance11311083romance_
romanced1337253romanced
romancer1247293romancer
romancers1345733romancers
saices84221803s__aices
sanes55649073s__an_es
sanies63031953s__anies
sauces84919503s__auces
sciences1238773sciences
sconces113811453s_conces
seance83716693s_eance_
senates73322613sena_tes
sentences11610303sentences
shannies113411263shannies
silanes72517163silan_es
silences10310073silences
skeanes113610713skean_es
snacks124514553s_na_cks
snakes103919603s_na_kes
snares65329033s_na_res
snashes105214753s_nashes
snatches131410713s_natches
snathes104816493s_nathes
soaves94218673so_a_ves
socages101012053soca_ges
solace83415823sola_ce_
solaced102911063sola_ced
solacer93011103sola_cer
solacers10268893sola_cers
solander948123solander
solanders1036963solanders
solands84412343solan_ds
solanines9310083solanines
solanins8310513solanins
solanos74412853solan_os
solans64122493solan__s
solanums1044433solanums
solates73523853sola_tes
somans84619303soman__s
sonant6621953sonan__t
sonantal886263sonantal
sonantic1048273sonantic
sonarmen1045253sonarmen
sonars64818973sona__rs
sonatas7510293sona_tas
sondes74922873so__ndes
sones55444143so__n_es
sonics84315633son_ic_s
sonnet65923503son_n_et
sonnets74211993son_nets
sources9312173so_urces
soutanes8312933soutan_es
sowans94215893sowan__s
sozines16611263sozin_es
spaces104722633s_pa_ces
spancel1147363s_pancel
spancels1245273s_pancels
spences113413923s_pences
stagnances1343343stagnances
stance84316913s_tance_
stanches132312793s_tanches
stanes64933403s_tan_es
stranges94516763stranges
synanons1144633synanons
synapses1344713synapses
tenaces92814513tena_ces
tenancies1149173tenancies
tendances1247573tendances
tolanes74216313tolan_es
tonnages9187873tonnages
tonnes65320853ton_n_es
trances93919643_trances
usances967373_usances
valances1398763valances
voidances1544473voidances

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 Limit1461621586.59322169.3
3Display Results1581580.0632507.9
 (SQL Overall)1786911587.07925242.4
 
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.