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

161 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
unsnap83620(None) 
unsnag736391unsnag
unsnaps935421unsnaps
snap65727032__snap
uncap9312282un_cap
unsay83212842uns_ay
unseal63315472unseal
unseam83313142unseam
unseat64221022unseat
unsharp1235542unsharp
unship1148032unship
unsnags835462unsnags
unsnarl7107152unsnarl
unstep839222unstep
unstop837472unstop
unstrap946782unstrap
unwrap11126322unwrap
anna45529013an_na_
annal56520763an_nal
annas55824883an_nas
ansa45927773ans_a_
ansae55720973ans_ae
catnap1098383catnap
dognap1035343dognap
ensnare767123ensnare
ensnarl784913ensnarl
entrap8710563entrap
enwrap1185213enwrap
gunship1345383gunship
insane6314893insane
inscape1138023inscape
inseam8329993inseam
insnare748243insnare
inspan837513inspan
instal6712193instal
instar6310013instar
instep838193instep
inwrap11115903inwrap
jnana12159043jnana_
jnanas13207303jnanas
kidnap1334193kidnap
knap105815403__knap
mishap1338873mishap
nana46632903_nana_
nanas55928633_nanas
nap56753203___nap
neap66927013_n_eap
nona46929063_nona_
nonas55126653_nonas
petnap1037423petnap
sap56463233__s_ap
slap66434043__slap
snag55827873__snag
snaps74719563__snaps
snaw78923073__snaw
sneap75514823sn_eap
snip66424653__snip
soap65831133__soap
sunna55016063sun_na_
sunnah9369353sun_nah
sunnas63914563sun_nas
swap95925433__swap
ulna46317333u_lna_
ulnad65611453u_lnad
ulnae55214573u_lnae
ulnar56013983u_lnar
ulnas55716533u_lnas
unai44824783u__nai
unapt710421593u__napt
unau43924153u__nau
unban72114333un_ban
unbans81912623unbans
unbar71913613un_bar
unbear889163unbear
uncaps1039813un_caps
uncia75015163uncia_
unciae83215313unciae
uncial83715223uncial
uncinal959963uncinal
unclad938913unclad
unclamp1344993unclamp
unclasp1135963unclasp
unclip1046993unclip
undead82711903undead
undrape1049333undrape
undraw1037813undraw
ungual738183ungual
unhand10410383unhand
unhang1038443unhang
unhat81119263un_hat
unhip10178823un_hip
unisonal845373unisonal
unjam1448723un_jam
unknit1068593unknit
unknot1037413unknot
unlay84613703un_lay
unlead73312373unlead
unload73010803unload
unman72715423un_man
unmans82211993unmans
unnail6410583un_nail
unread73412673unread
unreal64414453unreal
unrip72012863un_rip
uns35936763uns___
unsafe9310693unsafe
unsaid7411833unsaid
unsawn9317463unsawn
unsays9399543unsays
unseals73212573unseals
unseams9338913unseams
unseats73012853unseats
unseen62012623unseen
unsell63512543unsell
unsent63820963unsent
unset54532433uns_et
unsets64116163unsets
unsew83912693uns_ew
unsewn9298393unsewn
unsews9379363unsews
unsex123512633uns_ex
unsexy16296903unsexy
unshaped14148443unshaped
unshapen13155443unshapen
unshed10313773unshed
unships1237203unships
unshod1067603unshod
unshut939013unshut
unsmart939603unsmart
unsnapped1443983unsnapped
unsnarls894883unsnarls
unsold71410513unsold
unsoncy1245513unsoncy
unsonsy1045023unsonsy
unsown9328433unsown
unspeak1344793unspeak
unspun865793unspun
unstack1337373unstack
unstate71916213unstate
unsteps936213unsteps
unstops936993unstops
unstraps1045983unstraps
unsung736983unsung
unsunk1036333unsunk
unsure62815413unsure
unswear1035003unswear
unswept1246013unswept
unusual743943unusual
unwraps1255513unwraps
unzip16207623un_zip
upheap13105213upheap
upleap10106843upleap
upsoar8105683upsoar
upstep1035503upstep
urinal6614123urinal
ursa44116913urs_a_
ursae55214453urs_ae
usnea539393u_snea
usneas638333usneas
usual5310183u_sual
usurp7106903u_surp

Search took 6 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 Filter1786911127160.373479064.3
2DLD Change Limit1127161614.95622743.3
3Display Results1611610.0463500.0
 (SQL Overall)1786911615.37533244.8
 
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.