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

48 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
inclasping154380(None) 
enclasping1544101enclasping
unclasping1544121unclasping
beclasping17134072beclasping
clasping133310262__clasping
incasing11610602inc_as_ing
inclipping1742902inclipping
inclosing1257652inclos_ing
reclasping15105082reclasping
unclamping1743432unclamping
clamping154011153__clamping
clapping153810603__clapping
clashing143812193__clashing
classing113211793__classing
declassing1445123declassing
encamping1645233enc_amping
encashing1536443enc_ashing
encasing11610823enc_as_ing
enchasing1567733enchas_ing
enclaving1546313encla_ving
enclosing1257573enclos_ing
incaging1288673inc_a_ging
incanting1289903inc_anting
incensing1297663incens_ing
incising11411093inc_is_ing
inclasp1145303inclasp___
inclasped1463553inclasp_ed
inclasps1244353inclasp__s
inclining1248403incl_ining
including1344993incl_uding
incorpsing1544433incorpsing
increasing1346323increas_ing
incrossing1345023incrossing
incrusting13126473incrusting
incusing1159953inc_us_ing
inflaming1546263infla_ming
inflating13310443infla_ting
inlacing1158373in_la_cing
inlaying1247893in_la_ying
inwrapping1842793inwrapping
misclassing1644123misclassing
uncapping1635133unc_apping
uncasing11511003unc_as_ing
unceasing1239653unceas_ing
unclipping1743313unclipping
unclosing1247753unclos_ing
unlashing1336493un_lashing
windlassing1651823windlassing

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 Filter1786911406030.403443402.0
2DLD Change Limit140603485.66024841.5
3Display Results48480.0301600.0
 (SQL Overall)178691486.09329327.3
 
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.