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

115 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
endwise113646(None) 
bendwise1443411bendwise
anywise1345202anywise
endite73817592end_ite
endive103310472end_ive
endorse879202endorse
entwine1039142entwine
entwist1048802entwist
nowise9511072_nowise
unwise9510802un_wise
advise10139223_advise
airwise1036713airwise
anise55129703an__ise
dendrite1048783dendrite
dwine95616143__dwine
ebonise939613ebonise
eddies83313163e_ddies
edgewise1342733edgewise
edile64819493e_d_ile
elegise8139393elegise
emprise11310723emprise
enamine91214313enamine
encase83714363en_case
enchase1239463enchase
enclose999993enclose
endash10297123end_ash
endemism1345483endemism
enders74324053enders_
endexine1646083endexine
endgame1145233endgame
ending83220253end_ing
endited93512913end_ited
endites83717063end_ites
endives113710693end_ives
endless839833endless
endmost1056763endmost
endnote855743endnote
endorsed1057193endorsed
endorsee968603endorsee
endorser966733endorser
endorses959973endorses
endowing13178173endowing
endows104610423endows_
endrin7312403endri_n
endrins8312163endrins
ends56528523end__s_
endue64215353end__ue
endues73813903endues_
enduing9249723enduing
endure74014143end_ure
endures83314603endures
endways1444443endways
enemies9313693enemies
energise947333energise
engine71114863en_gine
english1137953english
enisle63412093en__isle
enlist6417043en_list
ennuis636473ennuis_
enokis103010273enokis_
enolase7310193enolase
enosis63816423enosis_
enosises8311003enosises
enows85115493enow_s_
enquire16287213enquire
ensile62616473en_sile
enskies1138573enskies
enthuse1046963enthuse
entice81316863en_tice
entire61617703en_tire
entries71523163entries
entwined1235843entwined
entwines1148753entwines
entwisted1343803entwisted
entwists1156143entwists
envies9314053en_vies
envois988703envois_
enwind10298083en_wind
excise1538553e_xcise
fanwise1336633fanwise
fesswise1442353fesswise
genoise839423gen_oise
incise83515333in_cise
indie63721473ind_i_e
indies73822783ind_ies
indite73520323ind_ite
indorse8108193indorse
indris7311963indris_
intwine1038513intwine
intwist1038043intwist
iodise74214943iod_ise
longwise1244083longwise
manwise1239183manwise
midwife16225523midwife
neddies92710703neddies
newie81813483_newi_e
newies91014073_newies
newish1237903_newish
newsie9138213_newsie
noise55723733_n_oise
oldwife1492253oldwife
penalise101013763penalise
pennywise1751943pennywise
sidewise1245353sidewise
sunwise1036433sunwise
taxwise1734253taxwise
undies73821963und_ies
undine7817263und_ine
untwine1038623untwine
untwist1047713untwist
unwiser1037123un_wiser
unwish1239093un_wish
vendeuse1243023vendeuse
weftwise1741813weftwise
wise75737343___wise

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.406440125.6
2DLD Change Limit1340271157.17018692.7
3Display Results1151150.0462500.0
 (SQL Overall)1786911157.62223444.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.