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

107 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
synapse123413(None) 
synapsed1443131synapsed
synapses1344711synapses
asynapses1442022asynapses
shnaps1148082shnaps_
snaps74719562s_naps_
synapsid1444262synapsid
synapsis1345142synapsis
synopses1346222synopses
apse67725383___apse
asynapsis1452073asynapsis
byname13256363byna_me
bynames14256243bynames
canape10913513canap_e
canapes111213083canapes
dynast1088223dyna_st
elapse857523_elapse
gyrase10508773gyra_se
kinase104210653kina_se
knaps115511173_knaps_
kyanise14236143kyanise
lapse74917683__lapse
lyase85512413ly_a_se
mynahs14416443mynahs_
mynas105815233myna_s_
nape65230803__nap_e
napes74828463__napes
nappe96114993__nappe
naps66238583__naps_
relapse947703relapse
saps65346373s__aps_
sarape84817573sarap_e
sarapes94617753sarapes
scape96921843s_cap_e
scapes105122263s_capes
scapose1147753s_capose
schappe1635273schappe
schnaps1443703schnaps_
scrape105917573scrap_e
scrapes116217663scrapes
scrapie115010943scrapie
scraps106017243scraps_
senate63725173sena_te
senates73322613senates
sense55526823sen__se
serape84818413serap_e
serapes95218103serapes
shape105125113s_hap_e
shapes115124953s_hapes
shnapps1463343shnapps
sinapism1245573sinapism
sinopie948783sinopie
skycaps1842703skycaps_
slaps76025713s_laps_
snags64421313s_nags_
snake94821113s_na_ke
snakes103919603s_nakes
snap65727033s_nap__
snapped124611203s_napped
snapper113512073s_napper
snappy1366103s_nappy
snare54429983s_na_re
snares65329033s_nares
snash84815673s_na_sh
snathe94415113s_nathe
snaws86116363s_naws_
sneaps84510863sneaps_
snipe75320573s_nip_e
snipes83917393s_nipes
snips75818013s_nips_
soaps75120713s_oaps_
sonance9310313sonance
sonars64818973sonars_
sparse84516343s_parse
stapes85028733s_tapes
staple84415823s_taple
straps87721783straps_
sunrise7310813sunrise
sunups837263sunups_
sunwise1036433sunwise
swaps104819203s_waps_
synagog1243623synagog
synanon1044743synanon
synapsids1543223synapsids
synapsing1583483synapsing
synaptic1546283synaptic
syncarps1543903syncarps_
synchs14408453synchs_
syncope1445383syncope
syncopes1545763syncopes
syncs104610173syn_cs_
syndeses1245263syndeses
syne75725763syn___e
syngas10368913syngas_
syngases1245073syngases
syngasses1343813syngasses
synods1077953synods_
synopsis1346653synopsis
synopsize2353813synopsize
syntaxes1843633syntaxes
synths12377883synths_
synurae1044253synurae
syrups11277953syrups_
sysops1136013sysops_
vinasse1044513vinasse
yaps95933523_y_aps_
zymase201997483zyma_se

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 Limit1340271075.98322401.3
3Display Results1071070.0303566.7
 (SQL Overall)1786911076.41927837.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.