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 “unwisest” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

84 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
unwisest116512(None) 
unripest1046082unripest
unwise9510802unwise__
unwisely1444462unwisely
unwiser1037122unwise_r
unwishes14147482unwishes_
wisest95016442__wisest
anises64826693an_ises_
antsiest8511463antsiest
concisest1348253concisest
cowiest123614673cowi_est
dewiest11312343dewi_est
dungiest102810743dungi_est
funkiest152810973funki_est
funniest113010733funni_est
gunkiest132610573gunki_est
hunkiest153812333hunki_est
incises93414893incises_
inkiest113415043inki_est
junkiest192610173junki_est
lewises1039133lewises_
luniest73516993lun_i_est
naivest10309473_naivest
newsiest11107483newsiest
nicest82315663_n_icest
noises65021853_noises_
noisiest839763_noisiest
nosiest73415673_nosiest
nutsiest82710243nutsiest
puniest92918093pun_i_est
punkiest149312663punki_est
punniest102511583punni_est
runniest82911203runni_est
runtiest83014513runti_est
snidest8310913sn_idest
snowiest1138143snowi_est
sunniest82712913sunni_est
sunrises8310693sunrises_
sunwise1036433sunwise__
ugliest8410153ugli_est
unblest9411813un_blest
uncases93516553uncases_
undies73821963undi_es_
undines8716083undines_
undrest8313013un_drest
uneases73316263uneases_
uneasiest946563uneasiest
unfairest1243563unfairest
unfixes17238113unfixes_
uniquest1775603uniquest
unisex1358353un_ise_x
unites65024853un_ites_
unkindest1444993unkindest
unkissed1334893unkissed
unlives102010953unlives_
unmixes16197753unmixes_
unpiles92112783unpiles_
unrest62918853un__rest
unrisen7229283unrise_n
unseat64221023un__seat
unsent63820963un__sent
unset54532433un__se_t
unsets64116163un__sets
unsilent849603unsilent
untidiest1046033untidiest
unties64326923unti_es_
untruest847783untruest
untwines1137603untwines_
untwist1047713untwi__st
untwists1144623untwists_
unwariest1246033unwariest
unwept11389813unw__ept
unwet84423173unw__e_t
unwifely1743603unwifely
unwinds11286733unwinds_
unwisdom1441813unwisdom
unwish1239093unwi__sh
unwished15237833unwished
unwit84417523unwi___t
unwits9389893unwi_ts_
uprises92012733uprises_
widest104517003__widest
wisent93516343__wisent
wises85633193__wises_

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 Filter1786911461620.420425454.8
2DLD Change Limit146162846.31323152.5
3Display Results84840.0332545.5
 (SQL Overall)178691846.76626410.1
 
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.