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

113 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
unclasp113596(None) 
enclasp1145841enclasp
inclasp1145301inclasp
unclamp1344991unclamp
unclasps1244571unclasps
beclasp1335262beclasp
clasp95517192__clasp
enclasps1245132enclasps
inclasps1244352inclasps
reclasp1136642reclasp
uncap9312282unc_a_p
uncaps1039812unc_aps
uncase83817432unc_ase
uncast84215712unc_ast
unclad938912uncla_d
unclamps1443692unclamps
unclasped1465502unclasped
unclassy1343652unclassy
uncles8317162uncles_
unclip1046992uncl_ip
unclips1136432unclips
unclose91111642unclose
unlash938792un_lash
anlas55626933an_las_
beclasps1444353beclasps
clamp115517653__clamp
clap86429043__cla_p
claps95626183__claps
clash106219033__clash
clasps104512093__clasps
claspt104513413__claspt
class75525483__class
clast76030583__clast
cyclase1436613cyclase
declass1038733declass
encamp1235943enc_amp
encase83714363enc_ase
encash11276943enc_ash
enchase1239453enchase
enclasped1454213enclasped
enclave1257533enclave
enclose999993enclose
enolase7310193enolase
euclase938933euclase
handclasp1742863handclasp
incase83615283inc_ase
inclasped1463553inclasped
inclip1036823incl_ip
inclips1135963inclips
inclose9910223inclose
inulase739413inulase
nalas55528363_nalas_
nonclass1046243nonclass
nuclease1046213nuclease
nuncles939843nuncles_
outclass1037203outclass
reclasps1235053reclasps
subclass1246623subclass
sunglass945093sunglass
sunlamp1144163sun_lamp
tieclasp1242803tieclasp
unblest9411813unblest
uncage93014873unc_age
uncake122813523unc_ake
uncased104216953unc_ased
uncases93516553unc_ases
unchain1238943unchain
unchair1236163unchair
unchary1537263unchary
unchaste1346923unchaste
uncia75015163uncia__
unciae83215313uncia_e
uncial83715223uncia_l
uncials92510523uncials
unclamped1664503unclamped
unclasping1544123unclasping
unclawed1457983unclawed
uncle7317053uncl__e
unclean946973unclean
unclear936573unclear
uncleft1257493uncleft
uncloak1365473uncloak
uncloaks1444133uncloaks
unclog956603uncl_og
unclogs1036803unclogs
unclosed111010503unclosed
uncloses10910943uncloses
uncloud1046433uncloud
uncos74117033unc_os_
uncrate9415953uncrate
uncrazy2144063uncrazy
uncross938193uncross
uncus74014983unc_us_
unease63816643un_ease
uneasy9278853un_easy
unflashy1741863unflashy
unlace82215173un_lace
unlade72714153un_lade
unlaid7311753un_laid
unlay84613703un_la_y
unlays93810493un_lays
unleash1034963unleash
unless62413073un_less
unmask1265903un_mask
unplait948603unplait
unsharp1235543unsharp
unsnap836203unsna_p
unsnaps935423unsnaps
unwrap11126323unwra_p
unwraps1255513unwraps
upcast102710093upc_ast
upcoast1165543upcoast
uvulas946523uvulas_

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 Limit1340271136.04622167.9
3Display Results1131130.0303766.7
 (SQL Overall)1786911136.48227567.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.