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

156 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
unsnag73639(None) 
unsnags835461unsnags
unsnap836201unsnap
snag55827872__snag
unhang1038442unhang
unsay83212842uns_ay
unseal63315472unseal
unseam83313142unseam
unseat64221022unseat
unsnaps935422unsnaps
unsnarl7107152unsnarl
unsung736982unsung
anna45529013an_na_
annal56520763an_nal
annas55824883an_nas
ansa45927773ans_a_
ansae55720973ans_ae
bisnaga1042853bisnaga
dunnage9175213dun_nage
ensnare767123ensnare
ensnarl784913ensnarl
gasbag1035413gasbag
innage73011573in_nage
insane6314883insane
inseam8329993inseam
insnare748243insnare
inspan837513inspan
instal6712183instal
instar6310013instar
jnana12159043jnana_
jnanas13207303jnanas
linsang835863linsang
nag46450813___nag
nana46632893_nana_
nanas55928633_nanas
nona46929063_nona_
nonage7313683_nonage
nonas55126653_nonas
onstage838363onstage
outsang83411273outsang
padnag1036073padnag
sag46163403__s_ag
sang55441223__sang
scag76626893__scag
shag86430563__shag
skag96321513__skag
slag55934353__slag
snags64421313__snags
snap65727033__snap
snaw78923073__snaw
snog55623633__snog
snug55218693__snug
stag57332003__stag
sunna55016063sun_na_
sunnah9369353sun_nah
sunnas63914563sun_nas
swag87526733__swag
tuning74016843tunin_g
tunnage8166373tun_nage
ulna46317323u_lna_
ulnad65611453u_lnad
ulnae55214573u_lnae
ulnar56013983u_lnar
ulnas55716533u_lnas
unai44824783u__nai
unau43924153u__nau
unban72114333un_ban
unbans81912623unbans
unbar71913613un_bar
unbear889163unbear
uncage93014873un_cage
uncap9312283un_cap
uncia75015163uncia_
unciae83215313unciae
uncial83715223uncial
uncinal959963uncinal
unclad938913unclad
unclog956603unclog
undead82711903undead
undraw1037813undraw
ungual738183ungual
unhand10410383unhand
unhangs1136203unhangs
unhat81119263un_hat
unhung1035283unhung
unisonal845373unisonal
unitage838993unitage
unjam1448723un_jam
unknit1068593unknit
unknot1037413unknot
unlay84613703un_lay
unlead73312373unlead
unload73010803unload
unman72715423un_man
unmans82211993unmans
unnail6410583un_nail
unpeg8309363un_peg
unplug954413unplug
unread73412673unread
unreal64414453unreal
unrig61711413un_rig
uns35936753uns___
unsafe9310693unsafe
unsaid7411833unsaid
unsawn9317463unsawn
unsays9399543unsays
unseals73212573unseals
unseams9338913unseams
unseats73012853unseats
unseen62012623unseen
unsell63512543unsell
unsent63820963unsent
unset54532433uns_et
unsets64116163unsets
unsew83912693uns_ew
unsewn9298393unsewn
unsews9379363unsews
unsex123512633uns_ex
unsexy16296903unsexy
unsharp1235543unsharp
unshed10313773unshed
unship1148033unship
unshod1067603unshod
unshut939013unshut
unsling8313643unsling
unslung844563unslung
unsmart939603unsmart
unsnagged1243123unsnagged
unsnarls894883unsnarls
unsold71410513unsold
unsoncy1245513unsoncy
unsonsy1045023unsonsy
unsown9328433unsown
unspeak1344793unspeak
unspun865793unspun
unstack1337373unstack
unstate71916213unstate
unstep839223unstep
unstop837473unstop
unstrap946783unstrap
unstung834853unstung
unsunk1036333unsunk
unsure62815413unsure
unswear1035003unswear
unusual743943unusual
unwrap11126323unwrap
upsoar8105683upsoar
upstage10167443upstage
urinal6614123urinal
ursa44116903urs_a_
ursae55214453urs_ae
usage6410213u_s_age
using66317963u_sing
usnea539393u_snea
usneas638333usneas
usual5310183u_sual

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 Filter1786911127160.1431249587.4
2DLD Change Limit1127161566.51617298.3
3Display Results1561560.0602600.0
 (SQL Overall)1786911566.71926594.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.