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

65 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
encysting154461(None) 
encashing1536442encashing
encasing11610822encas_ing
encrusting13125292encrusting
encrypting1843052encrypting
enlisting1038342enlisting
accosting1446733accosting
casting104628343__casting
costing104323023__costing
cystine1239333__cystine
easting84924303e__asting
egesting1039013e_gesting
enacting11311363en_acting
encaging1258733enc_aging
encamping1645233encamping
enchanting1645943enchanting
enchasing1567733enchasing
enclasping1544103enclasping
enclaving1546313enclaving
enclosing1257573enclosing
encoding1239043enc_oding
encoring11312173enc_oring
encyst1136203encyst___
encysted1444293encyst_ed
encystment1754243encystment
encysts1244313encyst__s
enditing10311073en_diting
enisling949633en_isling
enmeshing15114873enmeshing
enrooting10128133enrooting
ensuing8239543en__suing
entrusting11126183entrusting
entwisting1443853entwisting
envying1435713envy__ing
escorting1237713escorting
escoting1158713esc_oting
excepting2145873excepting
excessing1945713excessing
excising1837213excis_ing
exciting1838023exc_iting
excreting1946433excreting
excusing1836503excus_ing
existing1639073e_xisting
incanting1289903incanting
incasing11610603incas_ing
incenting12912063incenting
incepting1489293incepting
incising11411093incis_ing
inciting11312533inc_iting
incrusting13126473incrusting
incusing1159953incus_ing
infesting13109513infesting
ingesting11129623ingesting
insisting1038823insisting
investing13119393investing
nesting84320443_n_esting
recasting122414233recasting
renesting102514703ren_esting
trysting12267053_trysting
uncasing11511003uncas_ing
uncoating12611923uncoating
uncrating12813183uncrating
unresting10311133unresting
upcasting1434823upcasting
webcasting1842483webcasting

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 Filter1786911486410.440406115.9
2DLD Change Limit148641657.45319943.8
3Display Results65650.0302166.7
 (SQL Overall)178691657.92322553.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.