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

408 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
unsure6281541(None) 
ensure63416001ensure
insure63416601insure
unpure82911531unpure
assure6610772assure
censure92310602censure
endure74014142endure
ensue54013832ensu_e
ensured83512942ensured
ensurer73011902ensurer
ensures73315902ensures
enure53520222en_ure
injure133410862injure
insured83714252insured
insurer73312802insurer
insures73117262insures
inure54119052in_ure
rasure6311422rasure
sure45447412__sure
tonsure758782tonsure
uncurb1037042uncurb
uncured10513232uncured
uncurl839412uncurl
uncute82912132uncute
undue66715552undu_e
unfurl937952unfurl
unhurt9311252unhurt
unsafe9310692unsafe
unscrew1245462unscrew
unsoured9310052unsoured
unsung736982unsung
unsunk1036332unsunk
unsurely1146382unsurely
unswore1039052unswore
untrue6310772untrue
untune62511602untune
upsurge10134332upsurge
usurer638102u_surer
usurp7106902u_surp
usury887622u_sury
abjure1536733abjure
absurd935903absurd
adjure1435833adjure
allure63012943allure
ansae55720973ans_ae
ansate64517863ansate
answer936893answer
antre55224523an_tre
armure8710133armure
assume897563assume
assured858373assured
assurer767783assurer
assures7611403assures
azure14911483_azure
bistre83815023bistre
censured11248913censured
censurer10228133censurer
censures102211623censures
cesura838763cesura
cesurae937703cesurae
closure9278473closure
coinsure1046923coinsure
colure8314153colure
conjure16109063conjure
consume11510133consume
culture939393culture
cure66149123__cure
cynosure1343543cynosure
dasyure1153823dasyure
demure9311533demure
denture8311893denture
desire7415303desire
disuse74012833disuse
dure56341813__dure
encore8314773encore
endue64215353endu_e
endured93611213endured
endurer83210363endurer
endures83314603endures
enduro7338623enduro
ennuye973753ennuye
enquire16287213enquire
enserf9310763enserf
ensile62616473ensile
ensnare767123ensnare
ensued73610483ensued
ensues63313813ensues
ensurers8279373ensurers
entire61617703entire
enured73315333en_ured
enures63919713en_ures
erasure736943erasure
figure10258833figure
fissure1036783fissure
fixure16256543fixure
future939563future
gesture839243gesture
guipure1043533guipure
gunfire1134743gunfire
immure1036023immure
impure1038373impure
incisure1044553incisure
incur72212253incur_
incurs83012273incurs
incurve1236633incurve
incuse83513573incuse
induce93811533induce
indue63516673indu_e
infare9313083infare
infuse93110573infuse
inhere9313713inhere
inhume1196583inhume
injured15339063injured
injurer14318473injurer
injures143111173injures
injury16266143injury
inquire16227993inquire
insane6314883insane
insecure1044653insecure
insert64325253insert
inshore1038723inshore
inside7613443inside
insnare748243insnare
insole63515863insole
inspire938253inspire
insult62813673insult
insureds9277613insureds
insurers83710133insurers
inturn63411563inturn
inured73114813in_ured
inures63318953in_ures
inurn53712863in_urn
issue559213issu_e
issuer646623issuer
juncture1743903juncture
knaur9508253knaur_
knaurs10466963knaurs
knur85311973kn_ur_
knurl9398913kn_url
knurs94511153kn_urs
leisure736693leisure
ligure7279473ligure
lunule638433lun_ule
lure45142463__lure
lustre64011683lustre
manure8313653manure
mature8313463mature
measure939033measure
misuse83213643misuse
multure939183multure
munster93710523munster
mure65941333__mure
nacre75715363_nacre
nature6311263nature
neume74414403_neume
nitre57519683_nitre
nude56626273_n_ude
nuke85920753_n_uke
nurd56224343_n_urd
nurl45327243_n_url
nurse54420123_n_urse
nurture736643nurture
obscure1145333obscure
onshore10310013onshore
onside7511803onside
ordure756803ordure
parure8312523parure
pasture9311463pasture
posture9313253posture
puncture1245053puncture
punster92911103punster
pure65543333__pure
purpure1195993purpure
pursue84512253pursu_e
pursuer9338893pursuer
rasures7312013rasures
reinsure837913reinsure
resume8313783resume
resurge839073resurge
rondure837293rondure
rupture966163rupture
secure8513533secure
seisure738193seisure
sere46153473__sere
sire46150413__sire
snare54429983sn_are
snore55424953sn_ore
sore47059533__sore
stoure64814943stoure
subsere9311443subsere
subsume1146713subsume
sucre75019103__sucre
sue35651463__su_e
suer45334033__suer
sunburn945133sunburn
sunsuit748693sunsuit
supe65932763__supe
sura45740293__sura
surd56433813__surd
surer54833093__surer
surf76039313__surf
surge65027693__surge
suture6313203suture
tenure6311613tenure
tonsured976383tonsured
tonsures869133tonsures
tussore7317283tussore
tussur6357293tussur_
tussurs7356373tussurs
ugsome934783ugsome
ulster63712103ulster
umpire1047883umpire
unable83819223unable
unaired82916013unaired
unarm7314453un_arm
unary8315993un_ary
unassured1084343unassured
unau43924153unau__
unaus53216573unau_s
unaware1038033unaware
unbale83616403unbale
unbar71913613unbar_
unbars82113033unbars
unbe65319273un__be
unborn83310813unborn
unbred92613303un_bred
unburden11124293unburden
unburied11208513unburied
unburned11227413unburned
unburnt977413unburnt
unbusy1135213unbusy
uncage93014873uncage
uncake122813523uncake
uncase83817433uncase
unciae83215313unciae
uncle7317053un_cle
uncork1239043uncork
uncuff1436113uncuff
uncurbed1346903uncurbed
uncurbs1134913uncurbs
uncurled1168963uncurled
uncurls937123uncurls
uncursed1148963uncursed
uncus74014983uncu_s
uncut73219173uncu_t
unde55825483un__de
undee65327273un_dee
under64624213under_
undine7817263undine
undoer73113043undoer
undone7914253undone
undrew1037913un_drew
unduly1037823unduly
unease63816643unease
unensured1044933unensured
unfired112212453unfired
unfree9413203unfree
unfurled1277203unfurled
unfurls1035573unfurls
unfused11319503unfused
ungird887973ungird
ungirt71112713ungirt
unglue748003unglue
ungual738183ungual
unguard955093unguard
ungues7412123ungues
unguis738443unguis
ungula737603ungula
ungulae837313ungulae
unhired112512153unhired
unhorse1038583unhorse
unhouse1038923unhouse
unhung1035283unhung
unhusk1334263unhusk
uninsured1044863uninsured
unique1558163unique
uniquer1675783uniquer
unisize1647333unisize
unite54828383un_ite
uniter64619143uniter
unjust1337873unjust
unlace82215173unlace
unlade72714153unlade
unlike102614063unlike
unlive92712333unlive
unmade92911063unmade
unmake122811213unmake
unmitre936993unmitre
unnerve1066653unnerve
unpile81914323unpile
unpurely1344483unpurely
unpurged1236293unpurged
unquiet16310663unquiet
unquote1645903unquote
unripe82012093unripe
unrobe82611673unrobe
unrove92511683unrove
unruled8311373unruled
unruly938083unruly
uns35936753uns___
unsaid7411833unsaid
unsated83419933unsated
unsaved113312193unsaved
unsawed112911503unsawed
unsawn9317463unsawn
unsay83212843uns_ay
unsays9399543unsays
unscrews1343313unscrews
unseal63315473unseal
unseam83313143unseam
unseared91113943unseared
unseat64221023unseat
unsecured1244903unsecured
unseen62012623unseen
unsell63512543unsell
unsent63820963unsent
unserved12410233unserved
unset54532433uns_et
unsets64116163unsets
unsew83912693uns_ew
unsewed112911023unsewed
unsewn9298393unsewn
unsews9379363unsews
unsex123512633uns_ex
unsexed152410253unsexed
unsexes14248923unsexes
unsexy16296903unsexy
unshared121510703unshared
unsharp1235543unsharp
unshed10313773unshed
unship1148033unship
unshod1067603unshod
unshorn1036943unshorn
unshut939013unshut
unsized172510533unsized
unslung844563unslung
unsmart939603unsmart
unsnag736393unsnag
unsnap836203unsnap
unsnarl7107153unsnarl
unsober967623unsober
unsold71410513unsold
unsorted9312513unsorted
unsound8158433unsound
unsourced1244823unsourced
unsowed112511053unsowed
unsown9328433unsown
unsphere1355843unsphere
unspoke1336573unspoke
unspun865793unspun
unsquared1944063unsquared
unstate71916213unstate
unsteel738793unsteel
unstep839223unstep
unstop837473unstop
unstrap946783unstrap
unstress837373unstress
unstuck1345023unstuck
unstung834853unstung
unsubtle1043873unsubtle
unsuited9310783unsuited
unsworn1046843unsworn
untame82513603untame
untie54425493un_tie
untired82316383untired
untorn63012343untorn
untruer737113untruer
untuck1236403untuck
untuned82010823untuned
untunes72211253untunes
unturned9228563unturned
unurged939143un_urged
unused72012873unused
unusual743943unusual
unwary1239823unwary
unwise9510803unwise
unworn93411333unworn
unwove12238883unwove
unyoke1367293unyoke
upbore10247883upbore
upcurl1034963upcurl
upcurve1463273upcurve
upside9289803upside
upsize17267303upsize
upstare9158683upstare
upsurged12124043upsurged
upsurges11144803upsurges
uptore8279453uptore
upturn8286243upturn
urare56322553u_rare
ursae55214453urs_ae
ursine64114123ursine
usage6410213u_sage
use36835163u_s__e
user45023003u_ser_
users55817573u_sers
usher84517763u_sher
usque14137733u_sque
usual5310183u_sual
usurers766363u_surers
usuries7510633u_suries
usurped1035153u_surped
usurper934353u_surper
usurps8105073u_surps
velure939773velure
venture10311173venture
vesture10310373vesture
vulture1036763vulture

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 Limit1127164086.40617595.4
3Display Results4084080.2032009.9
 (SQL Overall)1786914086.75226464.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.