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

153 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
unitive1031056(None) 
punitive1346831punitive
unitize16310031unitize
auditive1247162auditive
fugitive1544172fugitive
genitive1247642genitive
lenitive1148492lenitive
monitive1349992monitive
native9613012_native
unisize1647332unisize
unitage838992unitage
unite54828382unit__e
unities72520142unities
uniting8315822uniting
unitively1586172unitively
unitized1839212unitized
unitizer1746202unitizer
unitizes1739132unitizes
unlive92712332un_live
untie54425492un_ti_e
active11313743_active
additive1345863additive
amative12311733amative
aniline7418473aniline
anytime1246043anytime
auditives1345723auditives
auntie64317703aun_ti_e
captive1438973captive
cognitive1545483cognitive
conative131214623conative
costive12312843costive
curative13310403curative
dative10311813_dative
denotive1238673denotive
donative12139873donative
dunite7315013dunit__e
dunitic1048143duniti_c
durative1239073durative
elative10312453elative
emotive1239193emotive
enactive1338513enactive
endive103310473en_dive
entice81316863en_tice
entire61617703en_tire
festive1339773festive
fictive1537023fictive
fugitives1643543fugitives
furtive1337173furtive
genitives1346663genitives
gunite7414403gunit__e
inactive1348203inactive
incisive1346283incisive
initial7311883initial
initiate8412693initiate
intime81014263in_time
intine61021973in_tine
intuitive1246163intuitive
inutile739883inutile
lenitives1247503lenitives
motive113112143_motive
munition1038763munition
mutative1348283mutative
naive85116213_n_aive
natives10310823_natives
nieve85613183_ni_eve
nite45943583_nit__e
nitid61817833_niti_d
nitre57519683_nit_re
nitride82811243_nitride
nitrile73011373_nitrile
nitrite72314463_nitrite
nixie125114943_nixi_e
notice8313443_notice
nutritive1245333nutritive
onetime937623onetime
positive1349993positive
punition1038373punition
punitively18124823punitively
putative1348373putative
quintile1736843quintile
restive10315933restive
sanative11310473sanative
sanitise81511813sanitise
sanitize171410073sanitize
sensitive1246963sensitive
stative102612933stative
uintaite8127353uintaite
unagile838283unagile
unakite1138743unakite
unalike11311533unalike
unciae83215313un_ciae
unction9310663unction
undine7817263un_dine
unglove1136103unglove
uniface1236953uniface
unific1137463unifi_c
unified112413563unified
unifier102211863unifier
unifies102714713unifies
unionise847853unionise
unionize1747063unionize
unique1558163uni_que
unit45140073unit___
unitages938273unitages
unitard838003unitard
unitary1038613unitary
united74421543unit_ed
uniter64619143unit_er
uniters73814173uniters
unites65024853unit_es
unitizers1843923unitizers
units54923433unit__s
unity84918493unit__y
univalve1443473univalve
unlike102614063un_like
unlived112511373un_lived
unlives102010953un_lives
unmitre936993unmit_re
unnerve1066653unnerve
unpile81914323un_pile
unpitied1138773unpitied
unreeve10176763unreeve
unretire846963unretire
unripe82012093un_ripe
unrove92511683un_rove
unstate71916213unstate
unstick1338123unstick
untame82513603un_tame
untidy1059153un_tidy
untied73720813un_tied
unties64326923un_ties
until53517743un_ti_l
untimed102713363un_timed
untired82316383un_tired
untrue6310773un_true
untune62511603un_tune
untwine1038623untwine
unvoice12126153unvoice
unweave1336363unweave
unwhite1336813unwhite
unwise9510803un_wise
unwove12238883un_wove
updive1234903u_pdive
uptime1067663u_ptime
uridine81311213uridine
urinative1247653urinative
utile54718933u__tile
utilise749063utilise
utilize1648803utilize
visive1257873_visive
volitive1446893volitive
vomitive1645853vomitive
votive12348933_votive

Search took 9 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.310576422.6
2DLD Change Limit1340271537.80017182.9
3Display Results1531530.0463326.1
 (SQL Overall)1786911538.15621909.1
 
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.