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

118 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
unakites123754(None) 
unakite1138741unakite_
unites65024852un__ites
uralites82112722uralites
uranites82514642uranites
analcites1147483analcites
analities9715873analities
analytes11169203analytes
apatites10311283apatites
axites134913833__axites
bankits133410153bankit_s
barites94322333_barites
burkites1436673burkites
cyanites132610163cyanites
dacites101114593_dacites
dunites8313593dun__ites
dunnites947173dun_nites
dynamites1544623dynamites
egalites9310503egalites
enamines101112133enamines
enates64026423ena__tes
endites83717063en_dites
enskies1138573enski_es
gnathites1344233gnathites
granites92116363granites
gunites8313123gun__ites
halites103221193_halites
hankies143617763hanki_es
hunkies143214503hun_ki_es
hyalites14208833hyalites
inanities9312443inanities
incites93218483in_cites
indites83618983in_dites
inosites8312793inosites
invites103915813in_vites
junkies183711693jun_ki_es
kites95432543___kites
kunzites2143243kun_zites
kyanites15216683kyanites
lunacies1038013lunaci_es
mannites10312613mannites
monazites2046433monazites
naives94914223_na_ives
nasties73520493_nasties
nates55238333_na__tes
natives10310823_natives
navies95218623_navi_es
nites55736343_n__ites
norites74018803_norites
parakites1549543parakites
phenakites1963863phenakites
punkies134216803pun_ki_es
ratites74920683_ratites
runagates1044333runagates
ruralites947943ruralites
samites93118713_samites
skites104418043__skites
snakebites1652313snakebites
snakes103919603snak__es
snakier112810003snaki_er
snakiest122110543snaki_est
snakiness1367473snakiness
taxites1449673_taxites
uintahites13122793uintahites
uintaites9136333uintaites
ulexites1534943ulexites
umangites1244483umangites
unabated11310133unabated
unacted10312733una_cted
unagile838283unagile_
unaided92414603una_ided
unaimed102812493una_imed
unaired82916013una_ired
unais53420773una_i__s
unakin10310963unaki__n
unalike11311533unalike_
unaudited1145853unaudited
unawares1137053unawares
uncakes133012743uncak__es
uncrates10314563uncrates
undies73821963un_di_es
undines8716083un_dines
unedited10249833unedited
unfaiths1443213unfaiths
unfits93910293un_fit_s
unfixes17238113un_fixes
unifies102714713unifi_es
unite54828383un__ite_
united74421543un__ited
uniter64619143un__iter
uniters73814173un__iters
unities72520153un__ities
unitizes1739133unitizes
units54923433un__it_s
unkinks10265413un_kinks
unknits1135553unknit_s
unlives102010953un_lives
unmakes132810793unmak__es
unmiter9310393un_miter
unmiters1037073un_miters
unmitres1036863un_mitres
unmixes16197753un_mixes
unpiles92112783un_piles
unquiets1744313unquiets
unquotes1745353unquotes
unstates81314993unstates
unsuited9310793unsuited
unties64326923un_ti_es
untwines1137603untwines
ununited938683ununited
unvoices13125163unvoices
unwhite1336813unwhite_
unwits9389893un_wit_s
uralite71714103uralite_
uranides92211283uranides
uranite72515693uranite_
urates65027763ura__tes
urbanites11105913urbanites

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 Filter1786911461620.1561145455.1
2DLD Change Limit1461621187.62319173.8
3Display Results1181180.0462565.2
 (SQL Overall)1786911187.82522835.9
 
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.