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

131 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
unakite113874(None) 
unakites1237541unakites
unagile838282unagile
unakin10310962unaki_n
unalike11311532unalike
unite54828382un__ite
unwhite1336812unwhite
uralite71714102uralite
uranite72515692uranite
analcite1049333analcite
anality10313633anality
analyte10158813analyte
apatite9312963apatite
axite125218253__axite
bankit123617043bankit_
bankits133410153bankits
barite84224813_barite
burkite1337003burkite
cyanite122710763cyanite
dacite91115883_dacite
dunite7315013dun__ite
dunnite857333dun_nite
dynamite1444813dynamite
egalite8311563egalite
enamine91214313enamine
enate54428143ena__te
endite73817593en_dite
gnathite1244483gnathite
granite82017083granite
gunite7414403gun__ite
halite93624233_halite
hankie133915713hanki_e
hunkie133812383hun_ki_e
hyalite13229473hyalite
inanity1039503inanity
incite83618733in_cite
indite73520323in_dite
inosite7314063inosite
invite93715033in_vite
junkie17339603jun_ki_e
kite85338233___kite
kunzite2053503kun_zite
kyanite14237313kyanite
lunate6316043luna__te
mannite9312903mannite
monazite1957083monazite
naive85116213_na_ive
narine63422553_narine
native9613013_native
nite45943583_n__ite
norite63221133_norite
parakite14410423parakite
phenakite1864233phenakite
punkie123513613pun_ki_e
ratite65022423_ratite
runagate944293runagate
ruralite848963ruralite
samite83020603_samite
skite95120053__skite
snake94821113snak__e
snakebite1552903snakebite
snakier112810003snakier
snakily1436913snakily
snaking123915303snaking
taxite13511303_taxite
uintahite12113143uintahite
uintaite8127353uintaite
ulexite1445723ulexite
umangite1144823umangite
unabated11310133unabated
unable83819223una_ble
unacted10312733una_cted
unaging9510933unaging
unai44824783una_i__
unaided92414603una_ided
unaimed102812493una_imed
unaired82916013una_ired
unais53420773una_i_s
unapt710421593una_pt_
unaudited1145853unaudited
unawake1445343unawake
unaware1038033unaware
uncake122813523uncak__e
uncaking1539463uncaking
unciae83215313un_ciae
uncrate9415953uncrate
uncute82912133un_cute
undine7817263un_dine
unedited10249833unedited
unfaith1345783unfaith
unfit84518563un_fit_
unfits93910293un_fits
unisize1647343unisize
unit45140073un__it_
united74421543un__ited
uniter64619143un__iter
unites65024853un__ites
unitive10310563unitive
unitize16310033unitize
units54923433un__its
unity84918493un__ity
unkind113310573un_kind
unkink9308713un_kink
unknit1068593unknit_
unknits1135553unknits
unlike102614063un_like
unlit55025463un_lit_
unlive92712333un_live
unmake122811213unmak__e
unmaking1538133unmaking
unmiter9310393un_miter
unmitre936993un_mitre
unpile81914323un_pile
unpolite1049173unpolite
unquiet16310663unquiet
unquote1645903unquote
unripe82012093un_ripe
unstate71916213unstate
unsuited9310793unsuited
untie54425493un_ti_e
untwine1038623untwine
ununited938683ununited
unvoice12126153unvoice
unwise9510803un_wise
unwit84417523un_wit_
unwits9389893un_wits
uralites82112723uralites
uranide82212093uranide
uranites82514643uranites
urate55432163ura__te
urbanite1097183urbanite

Search took 8 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.1561145455.1
2DLD Change Limit1340271316.79619721.5
3Display Results1311310.0462847.8
 (SQL Overall)1786911316.99825534.6
 
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.