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

140 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
unclips113643(None) 
inclips1135961inclips
unclip1046991unclip_
clips96018302__clips
inclip1036822inclip_
uncaps1039812unc_aps
unclamps1443692unclamps
unclasp1135962unclasp
unclasps1244572unclasps
uncles8317162uncl_es
unclogs1036802unclogs
uncoils979532uncoils
unrips8199452un_rips
unships1237202unships
unzips17175272un_zips
anilins7416793anilins
blips95615783__blips
chips125721253__chips
claps95626183__claps
clip86924003__clip_
clipt96324273__clipt
clops95924853__clops
cyclins1438303cyclins
cyclops1635383cyclops
dunlins849553dun_lins
eclipse1144193_eclipse
encamps1335423encamps
enclasp1145843enclasp
enclasps1245133enclasps
fillips12298133fillips
flips105117743__flips
gunships1445173gunships
inclasp1145303inclasp
inclasps1244353inclasps
incline9314643incline
inclines10313143inclines
inulins7311493inulins
lips67141443___lips
munchies1539253munchies
nips65830923_n__ips
nucleins1046083nucleins
nucleus956573nucleus
nuclide1037173nuclide
nuclides1146553nuclides
nuncios937113nunc_ios
nuncles939843nuncl_es
oxlips1544433_oxlips
riflips1234163riflips
scrips105316033_scrips
slips76023723__slips
snips75818013sn__ips
tulips8137253_tulips
uglies7412323u_glies
unais53420773un_ai_s
unalike11311533unalike
uncages103213773uncages
uncakes133012743uncakes
uncap9312283unc_ap_
uncases93516553uncases
unchains1338303unchains
unchairs1345503unchairs
unchic1338643unchi_c
unci65019463unc_i__
uncia75015163unc_i_a
unciae83215313unc_iae
uncial83715223unc_ial
uncials92510523uncials
uncini8310153unc_ini
uncinus937403uncinus
unclad938913uncl_ad
unclamp1344993unclamp
unclassy1343653unclassy
uncle7317053uncl__e
unclean946973unclean
unclear936573unclear
uncleft1257493uncleft
unclinch1544873unclinch
unclipped1643843unclipped
uncloak1365473uncloak
uncloaks1444133uncloaks
unclog956603uncl_og
unclose91111643unclose
uncloses10910943uncloses
uncloud1046433uncloud
unclouds1144883unclouds
uncocks1537233uncocks
uncoil8811853uncoi_l
uncorks1337443uncorks
uncos74117033unc__os
uncross938193uncross
unction9310663unction
unctions1039733unctions
uncuffs1543143uncuffs
uncurbs1134913uncurbs
uncurls937123uncurls
uncus74014983unc__us
underlips12147673underlips
undies73821963un_dies
unfits93910293un_fits
unglues836993unglues
unguis738453ungui_s
unhairs1036373unhairs
unhip10178823un_hip_
unifies102714713unifies
unities72520153unities
units54923433un__its
unknits1135553unknits
unlays93810493un_lays
unless62413073un_less
unlike102614063un_like
unlink104011013un_link
unlinks11307403un_links
unlit55025463un_li_t
unlive92712333un_live
unlives102010953un_lives
unnails738223unnails
unpiles92112783unpiles
unpins82312383un_pins
unplaits1044813unplaits
unplugs1042983unplugs
unrigs7159003un_rigs
unrip72012863un_rip_
unripe82012093un_ripe
unship1148033unship_
unslick1356023unslick
unsling8313643unsling
unslings937283unslings
unsnaps935423unsnaps
unsteps936213unsteps
unstops936993unstops
unties64326923un_ties
untrims938613untrims
unveils1045753unveils
unwits9389893un_wits
unwraps1255513unwraps
unzip16207623un_zip_
upclimb1542133upclimb
upclimbs1641363upclimbs
upcoils1184933upcoils
urchins1238863urchins

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 Filter1786911340270.403443402.0
2DLD Change Limit1340271406.86019537.5
3Display Results1401400.0502800.0
 (SQL Overall)1786911407.31324434.7
 
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.