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

132 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
unchain123894(None) 
enchain1248851enchain
unchains1338301unchains
unchair1236161unchair
chain105723672__chain
enchains1348522enchains
munchkin1943232munchkin
unchained1537272unchained
unchairs1345502unchairs
unchary1537262unchary
unchic1338642unch_ic
unhair937332un_hair
urchin1138742urch_in
anchusin1344773anchusin
archaic1438823archaic
bunching163410703bunch_ing
cain65643913__c_ain
chai95929903__chai_
chaine115119223__chaine
chains114819703__chains
chair105519633__chair
chais107530313__chais
chin96934743__ch_in
cocain101315013coc_ain
cochair1446313cochair
cochin131313203coch_in
enchained1545493enchained
enchant12313103enchant
enchase1239453enchase
enchasing1567733enchasing
engrain838343engrain
entrain7313073entrain
fuchsin15124373fuchsin
hunching17309113hunch_ing
inching134414323inch_ing
ingrain839503ingrain
linchpin1553703linchpin
lochan1139093locha_n
luncheon1344013luncheon
lunching143110003lunch_ing
lynchpin1842273lynchpin
munching16299973munch_ing
munchkins2042913munchkins
mutchkin1943023mutchkin
nucha10229793nucha__
nuchae11218513nucha_e
nuchal11218873nucha_l
nuchals12216933nuchals
nuclein966123nuclein
nunchaku1742173nunchaku
pechan13511543pecha_n
prochain1548483prochain
puncheon1544473puncheon
punching163310123punch_ing
unai44824783un__ai_
unais53420773un__ais
unakin10310963un_akin
unban72114333un_ba_n
unbraid1037183unbraid
uncage93014873unc_age
uncaging1268713uncaging
uncake122813523unc_ake
uncaking1539463uncaking
uncanny1245113unc_anny
uncap9312283unc_a_p
uncaps1039813unc_aps
uncaring11312843uncaring
uncase83817433unc_ase
uncasing11511003uncasing
uncast84215713unc_ast
unceasing1239653unceasing
uncertain1146203uncertain
unchaining1645693unchaining
unchaired1536203unchaired
unchairing1644603unchairing
unchancy1844703unchancy
unchanging1745223unchanging
uncharge1446313uncharge
uncharging1744393uncharging
uncharming1844523uncharming
unchaste1346923unchaste
unchoke16248193unchoke
unchoking1935703unchoking
unchosen1356283unchosen
unci65019463unc__i_
uncia75015163unc__ia
unciae83215313uncia_e
uncial83715223uncia_l
uncials92510523uncials
uncini8310153unc__ini
uncivil1244793uncivil
unclad938913uncla_d
unclamp1344993unclamp
unclasp1135963unclasp
unclean946973unclean
unclip1046993unc_lip
uncoating12611923uncoating
uncoffin1643083uncoffin
uncoil8811853unc_oil
uncomic1346923uncomic
uncrate9415953uncrate
uncrating12813183uncrating
uncrazy2144063uncrazy
uncrown1236323uncrown
unction9310663unction
undrawn1145293undrawn
unfair936233un_fair
unhairs1036373un_hairs
unhand10410383un_hand
unhang1038443un_hang
unhat81119263un_ha_t
unhats91110623un_hats
unhewn12285253un_hewn
unhip10178823un_h_ip
unlaid7311753un_laid
unlearn735953unlearn
unman72715423un_ma_n
unnail6410583un_nail
unpaid939473un_paid
unpin72613243un__pin
unplait948603unplait
unsaid7411833un_said
unsawn9317463un_sawn
unshaken15175403unshaken
unshapen13155443unshapen
unsharp1235543unsharp
unshaven14154883unshaven
unship1148033unsh_ip
unshorn1036943unshorn
unthink1457003unth_ink
urchins1238863urch_ins
zechin20137703zech_in

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.1561145455.1
2DLD Change Limit1340271326.72019944.5
3Display Results1321320.0462869.6
 (SQL Overall)1786911326.92225814.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.