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 “deciphering” with Change Limit: [1] [2] [3] [4] [5]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

95 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
deciphering205322(None) 
ciphering17217702__ciphering
enciphering1952952enciphering
cyphering20175243__cyphering
decentering1546483decentering
decipher1644423decipher___
deciphered1943003decipher_ed
decipherer1852423decipher_er
decipherers1951783decipherers
decipherment2252533decipherment
deciphers1744393decipher__s
delivering1545173deli_vering
desilvering1663303desilvering
dithering1499853d__ithering
ensphering1644973_ensphering
lechering1538443lec__hering
telphering1644203te_lphering
bediapering1763044bediapering
befingering1843134befingering
bewildering1872704bewildering
blithering16116124_blithering
calipering1545004calip_ering
capering132414964__cap_ering
chippering2045164_chippering
cindering13311224__cindering
cohering142413834__c_ohering
coinhering1647314_coinhering
coppering162810894__coppering
coshering15510024__coshering
dackering1737384dac__kering
daikering1536104d_ai_kering
deairing10311894deai___ring
decentring1446754dec_entring
decerning1337294dec___erning
deciding132210834deci___ding
decimating1648754deci_mating
decipherable2251594decipherable
decipherments2361924decipherments
decisioning1543934decisioning
declaring1339574dec__laring
decoloring1486314dec_oloring
decolouring1583434decolouring
decreeing1335524dec__reeing
decupling1534974decup__ling
deepening1335614de_ep_ening
deflowering1952654deflowering
degendering1543634degendering
delighting1644994deligh_ting
delustering1344074delustering
demergering1653594demergering
denizening2142404deni_zening
deperming1537114de__p_erming
depleting1378194de__pleting
deploring1337854de__ploring
desiring10312144desi___ring
despairing1445064de_spairing
dewatering1545774de_watering
diapering1339034d__iapering
dickering1737464d__ickering
differing1746474d__iffering
domineering1553324domineering
feathering17108794fe_athering
inhering12913714___inhering
insphering1644194_insphering
kippering18205444__kippering
leathering1488684le_athering
leistering1147984le_istering
lippering14217884__lippering
ochering14219394_oc__hering
peppering1337084pe__ppering
peripheries1855004peripheries
recapturing1643764recapturing
rechewing1836494rec__hewing
recovering1647374rec_overing
refiltering1544824refiltering
regathering1645204regathering
registering1346394registering
rejiggering2182334rejiggering
repapering1547044repap_ering
resilvering1593744resilvering
sceptering1545794_sceptering
scuppering1754024_scuppering
semaphoring1952594semaphoring
skippering1943674_skippering
slithering1496894_slithering
sphering142811944___sphering
swithering17105214_swithering
syphering18175734__syphering
tempering1438734te_mp_ering
tethering1339134te__thering
tochering1537154toc__hering
unsphering1644284_unsphering
weathering1798354we_athering
withering16108814__withering
zippering23215204__zippering

Search took 10 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 Filter1786911488190.1601116818.8
2DLD Change Limit148819958.84316829.0
3Display Results95950.0601583.3
 (SQL Overall)178691959.06319716.5
 
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.