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

397 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
unciae8321531(None) 
uncia75015161uncia_
uncial83715221uncial
faciae112913412faciae
incise83515322incise
incite83618722incite
nuchae11218512nuchae
tunicae9328142tunicae
uncage93014872uncage
uncake122813522uncake
uncap9312282unc_ap
uncase83817432uncase
unci65019462unci__
uncials92510522uncials
uncinal959962uncinal
uncinate10312392uncinate
uncini8310152uncini
unclad938912unclad
uncle7317052unc_le
uncrate9415952uncrate
uncute82912132uncute
undine7817262undine
unite54828382un_ite
unlike102614062unlike
unlive92712332unlive
unpile81914322unpile
unripe82012092unripe
untie54425492unti_e
unwise9510802unwise
aecia73819283aecia_
aecial84817313aecial
ancillae1047653ancillae
ancone83916953ancone
anile54634463an_ile
anime75423203an_ime
anise55129703an_ise
ansae55720973an_sae
antae56828293an_tae
antiar6317173antiar
auntie64317703aunti_e
baccae12119703baccae
ciao64924183__ciao
cine66242943__cine
cire65836373__cire
cite65640343__cite
cnidae978143cnidae
conchae143911643conchae
concise11314473concise
curiae84518373curiae
dacite91115883dacite
deciare10710663deciare
decide104116873decide
decile94619213decile
docile94213123docile
dunce86319263dunc__e
duncical1345213duncical
duncish1335793duncish
dunite7315013dun_ite
dunnite857333dunnite
encage93713503encage
encase83714363encase
enchase1239453enchase
encina8310443encina
encinal949243encinal
encinas938723encinas
enclave1257533enclave
encode9310443encode
encore8314773encore
endite73817593endite
endive103310473endive
engine71114863engine
ensile62616473ensile
entia5318203entia_
entice81316863entice
entire61617703entire
enunciate1145743enunciate
excide1638423excide
excise1538553excise
excite15310883excite
facia103218463facia_
facial113615633facial
facias113415803facias
facile112514883facile
fasciae1247523fasciae
fecial114714623fecial
feriae95618603feriae
funicle12237483funicle
funkia1336343funkia_
funkias1435383funkias
gunfire1134743gunfire
gunite7414403gun_ite
hunkie133812383hunki_e
incage93513623incage
incase83615283incase
incisal947373incisal
incised102911583incised
incises93414893incises
incited103314623incited
inciter93113773inciter
incites93218483incites
incline9314643incline
income10712093income
incuse83513573incuse
indie63721463indi_e
indite73520313indite
inia45024693in_ia_
inside7613443inside
intimae9109743intimae
intime81014263intime
intine61021973intine
invite93715023invite
junkie17339603junki_e
knife1210010133kn_ife
kunzite2053503kunzite
lamiae84817453lamiae
lucite8313343lucite
lunulae735613lunulae
mediae94217413mediae
muscae10410673musc_ae
nae35952743_n__ae
naiad6313403_naiad
naive85116213_naive
nicad8312613_nicad
nice65534713_n_ice
niche105016793_niche
nide55535783_n_ide
nine45842173_n_ine
nite45943583_n_ite
nixe115722023_n_ixe
noise55723733_noise
novae85913123_novae
nubia7311223nubia_
nubias8310083nubias
nubile83212703nubile
nucha10229793nucha_
nuchal11218873nuchal
nuclide1037173nuclide
nudie65118673nudi_e
nuncio837973nunci_o
nuncios937113nuncios
nuncle839363nunc_le
nunlike11258073nunlike
once65423083onc__e
online6315843online
onside7511803onside
oscine8311563oscine
ounce77019933ounc__e
plicae10410953plicae
punctate1246473punctate
punkie123513613punki_e
racial83419243racial
recipe103414893recipe
recite83625113recite
rediae74221993rediae
runcinate1146473runcinate
snide64318723sn_ide
snipe75320573sn_ipe
social8813333social
spicae104313703spicae
striae65422273striae
suicide1038893suicide
sundae7312873sun_dae
sundial859863sundial
sunlike112310573sunlike
sunrise7310813sunrise
sunwise1036433sunwise
teniae64517353teniae
tibiae838473tibiae
tunica8379813tunica_
tunicate103310043tunicate
tunicle9308033tunicle
ulnae55214573u_lnae
umbrae1038673umbrae
umiac938953u_miac
umiak1137663u_miak
umiaq1656813u_miaq
umpire1047883umpire
unable83819223unable
unagile838283unagile
unai44824783un__ai
unaided92414603unaided
unaimed102812493unaimed
unaired82916013unaired
unais53420773unai_s
unakite1138743unakite
unalike11311533unalike
unau43924153un__au
unawake1445343unawake
unaware1038033unaware
unbale83616403unbale
unban72114333un_ban
unbar71913613un_bar
unbe65319273un__be
unbear889163unbear
unbiased1147143unbiased
unbid83214633unbi_d
unbind93011423unbind
unbrace111910483unbrace
unbrake13239123unbrake
uncaged113314123uncaged
uncages103213773uncages
uncaked143514353uncaked
uncakes133012743uncakes
uncaps1039813uncaps
uncased104216953uncased
uncases93516553uncases
uncast84215713uncast
unceded11410563unceded
unchain1238943unchain
unchair1236163unchair
uncharge1446313uncharge
unchary1537263unchary
unchaste1346923unchaste
unchic1338643unchic
unchoke16248193unchoke
uncially1339073uncially
uncinus937403uncinus
uncivil1244793uncivil
unclamp1344993unclamp
unclasp1135963unclasp
unclawed1457983unclawed
unclean946973unclean
unclear936573unclear
uncles8317163uncles
unclip1046993unclip
unclips1136433unclips
uncloak1365473uncloak
unclog956603unclog
unclose91111643unclose
unco66021403unc__o
uncoated11314963uncoated
uncock1438563uncock
uncoded11312743uncoded
uncoil8811853uncoil
uncoiled112512683uncoiled
uncoils979533uncoils
uncoined111813023uncoined
uncool8610113uncool
uncork1239043uncork
uncos74117033unc_os
uncover1239003uncover
uncoy104111413unc_oy
uncrated11416313uncrated
uncrates10314553uncrates
uncrazy2144063uncrazy
uncreate10311353uncreate
unction9310663unction
uncuff1436113uncuff
uncurb1037043uncurb
uncured10513233uncured
uncurl839413uncurl
uncus74014983unc_us
uncut73219173unc_ut
unde55825483un__de
undead82711903undead
undee65327273un_dee
undid72415363undi_d
undies73821963undies
undines8716083undines
undocile1145953undocile
undone7914253undone
undrape1049333undrape
undraw1037813undraw
undue66715553un_due
unease63816643unease
unfair936233unfair
unfired112212453unfired
unfit84518563unfi_t
unfits93910293unfits
unfix15429033unfi_x
unfixed18218563unfixed
unfixes17238113unfixes
unfixt16398423unfixt
unfree9413203unfree
ungird887973ungird
ungirt71112713ungirt
unglue748003unglue
ungual738183ungual
ungulae837313ungulae
unhair937333unhair
unhat81119263un_hat
unhinge11237283unhinge
unhip10178823unhi_p
unhired112512153unhired
uniface1236953uniface
unify113611113un_ify
union54519793un_ion
unique1558163unique
unisex1358353un_isex
unisize1647333unisize
unit45140073un_i_t
unitage838993unitage
united74421543un_ited
uniter64619143un_iter
unites65024853un_ites
unitive10310563unitive
unitize16310033unitize
units54923433un_its
unity84918493un_ity
unjam1448723un_jam
unkind113310573unkind
unkink9308713unkink
unlace82215173unlace
unlade72714153unlade
unlaid7311753unlaid
unlay84613703un_lay
unlead73312373unlead
unliked122411283unliked
unlined82515803unlined
unlink104011013unlink
unlit55025463unli_t
unlived112511373unlived
unlives102010953unlives
unload73010803unload
unmade92911063unmade
unmake122811213unmake
unman72715423un_man
unmined102612953unmined
unmiter9310393unmiter
unmitre936993unmitre
unmix14388973unmi_x
unmixed17228213unmixed
unmixes16197753unmixes
unmixt15378703unmixt
unnail6410583unnail
unoiled82415473unoiled
unpaid939473unpaid
unpick1446903unpick
unpiled102312743unpiled
unpiles92112783unpiles
unpin72613243unpi_n
unpins82312383unpins
unpure82911533unpure
unread73412673unread
unreal64414453unreal
unrig61711413unri_g
unrigs7159003unrigs
unrimed102211633unrimed
unrip72012863unri_p
unriper9188283unriper
unrips8199453unrips
unrisen7229283unrisen
unrobe82611673unrobe
unrove92511683unrove
unsafe9310693unsafe
unsaid7411833unsaid
unsay83212843un_say
unseal63315473unseal
unseam83313143unseam
unseat64221023unseat
unsized172510533unsized
unsnag736393unsnag
unsnap836203unsnap
unsocial1046073unsocial
unstate71916213unstate
unsure62815413unsure
untame82513603untame
untidy1059153untidy
untied73720813untied
unties64326923unties
until53517743unti_l
untimed102713363untimed
untired82316383untired
untrue6310773untrue
untune62511603untune
untwine1038623untwine
unviable1338703unviable
unvoice12126153unvoice
unweave1336363unweave
unwhite1336813unwhite
unwind102610543unwind
unwiser1037123unwiser
unwish1239093unwish
unwit84417523unwi_t
unwits9389893unwits
unwove12238883unwove
unwrap11126323unwrap
unyoke1367293unyoke
unzip16207623unzi_p
unzips17175273unzips
updive1234903updive
uppile10178503uppile
uprise82313693uprise
upside9289803upside
upsize17267303upsize
uptime1067663uptime
urbia7311133urbia_
urbias839083urbias
ureide7310363ureide
urial54823023u_rial
urine55026593u_rine
urnlike1136713urnlike
ursae55214453u_rsae
ursine64114123ursine
utile54718933u_tile
uvulae945323uvulae
zincite1837233zincite

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.1401276364.3
2DLD Change Limit1127163976.40617595.4
3Display Results3973970.1263150.8
 (SQL Overall)1786913976.67226782.2
 
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.