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

167 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
sunwise103643(None) 
sunrise7310811sunrise
unwise9510801_unwise
fanwise1336632fanwise
manwise1239182manwise
sunfish1338882sunfish
sunlike112310572sunlike
sunrises8310692sunrises
surmise9311082surmise
unwiser1037122_unwiser
unwish1239092_unwish
airwise1036713airwise
anise55129703_an_ise
anywise1345203anywise
auntie64317703aunti_e
aunties73920073aunties
bendwise1443413bendwise
bundist10310193bundist
bunnies94415003bunnies
concise11314473concise
duncish1335793duncish
dunite7315013dun_ite
dunnite857333dunnite
endwise1136463endwise
funnies104113603funnies
genoise839423genoise
guise64717713gu__ise
gunfire1134743gunfire
gunite7414403gun_ite
gunnies83413123gunnies
gunwale1134733gunwale
hunkie133812383hunki_e
hunkies143214503hunkies
hunnish1336163hunnish
huswife1642223huswife
incise83515333_incise
ionise63516943ion_ise
junkie17339603junki_e
junkies183711693junkies
kunzite2053503kunzite
longwise1244083longwise
lungis77113023lungis_
lunies64723013lun_ies
munis75022003mun_is_
noise55723733__noise
nowise9511073_nowise
nunlike11258073nunlike
nunnish1035933nunnish
outwile10310263outwile
outwish13289853outwish
punish111411503pun_ish
punjis1536693punjis_
punkie123513613punki_e
punkies134216803punkies
punkish16257693punkish
punties94520783punties
runtish1048693runtish
sanies63031953san_ies
sanitise81511813sanitise
seise54727853s__eise
senile63420213sen_ile
sense55526823sen__se
shunpike1742153shunpike
sidewise1245353sidewise
slantwise1242633slantwise
slowish1337633slowish
snide64318723s_n_ide
snipe75320573s_n_ipe
somewise1345553somewise
sonlike112110713sonlike
sonnies7315223sonnies
sonsie6614863sonsi_e
soubise9118793soubise
speise84614253s_peise
spunkie13215303spunki_e
spunkies14227593spunkies
stepwise1344163stepwise
stylise10208953stylise
suasive1037853suasive
subbase1139323subbase
suberise10813933suberise
subfile122010503subfile
sublime11310363sublime
subline9316893subline
submiss1138083submiss
subside10410453subside
subsist9311573subsist
subsite9412873subsite
subtile91912623subtile
sucrase9310343sucrase
sucrose939303sucrose
suffice15197573suffice
suffuse1335443suffuse
suicide1038893suicide
suite54829563su__ite
sulfide1138103sulfide
sulfite10310473sulfite
sulkies114315763sulkies
sullies74122233sullies
sumoist9311613sumoist
sunbird1044743sunbird
sundae7312873sun_dae
sundaes8313093sundaes
sundial859863sundial
sundries9312023sundries
sunfast1038503sunfast
sunfishes1547033sunfishes
sunless73013693sunless
sunlit61516103sunli_t
sunnas63914563sunnas_
sunnier73412153sunnier
sunniest82712913sunniest
sunnily1037833sunnily
sunning83715673sunning
sunns55017353sun_ns_
suns45841903sun__s_
sunset63723633sun__set
sunshine1147923sunshine
sunups837263sunups_
sunward1137653sunward
supine84216693su_pine
suppose1137973suppose
surbase939793surbase
surmised1136863surmised
surmiser1036763surmiser
surmises10310643surmises
surprise1037673surprise
survive1335933survive
sushis9311183sushis_
suspire937803suspire
swine85625303s__wine
swipe105217083s__wipe
swish115114823s__wish
swiss86712903s__wiss
swive115316193s__wive
synapse1234133synapse
taxwise1734253taxwise
tundish1137283tundish
tunnies73614263tunnies
unais53420773_unais_
uncase83817433_uncase
unciae83215313_unciae
undies73821963_undies
undine7817263_undine
unease63816643_unease
unisex1358353_un_isex
unite54828383_un_ite
unlike102614063_unlike
unlive92712333_unlive
unpile81914323_unpile
unripe82012093_unripe
unrisen7229283_unrisen
untie54425493_unti_e
unties64326923_unties
untwine1038623_untwine
untwist1047713_untwist
unwhite1336813_unwhite
unwind102610543_unwind
unwisely1444463_unwisely
unwisest1165123_unwisest
unwished15237833_unwished
unwishes14147483_unwishes
unwit84417523_unwi_t
unwits9389893_unwits
unwove12238883_unwove
uprise82313693_uprise
wise75737343___wise

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 Filter1786911340270.436409841.7
2DLD Change Limit1340271676.12621878.4
3Display Results1671670.0602783.3
 (SQL Overall)1786911676.62226984.4
 
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.