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

86 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
unspeak134479(None) 
unspeaks1443591unspeaks
bespeak1544572bespeak
outspeak1454582outspeak
respeak1335932respeak
speak114618672__speak
unseal63315472uns_eal
unseam83313142uns_eam
unseat64221022uns_eat
unspent92610892unspent
unswear1035002unswear
apeak115513453__apeak
bespeaks1643963bespeaks
inseam8329993ins_eam
inspan837513insp_an
inspect1138463inspect
instead836203instead
misspeak1643493misspeak
newspeak1742563newspeak
nonpeak1345473nonpeak
outspeaks1554013outspeaks
peak106535203___peak
respeaks1434953respeaks
sneak96016173__sneak
speaks125114583__speaks
spean74620513__spean
spear75821063__spear
speck135115653__speck
steak95219803__steak
unbear889163un_bear
unclean946973unclean
unclear936573unclear
uncloak1365473uncloak
undead82711903un_dead
unideal837103unideal
unlead73312373un_lead
unopen838913unope_n
unpack1457833un_pack
unpeg8309363un_pe_g
unpegs9256233un_pegs
unpen72913573un_pe_n
unpens82511013un_pens
unpent83117373un_pent
unpick1446903un_pick
unread73412673un_read
unreal64414453un_real
unsay83212843uns__ay
unseals73212573uns_eals
unseams9338913uns_eams
unseats73012853uns_eats
unseen62012623uns_een
unsell63512543uns_ell
unsent63820963uns_ent
unset54532433uns_e_t
unsets64116163uns_ets
unsew83912693uns_e_w
unsewn9298393uns_ewn
unsews9379363uns_ews
unsex123512633uns_e_x
unsexy16296903uns_exy
unshed10313773unshe_d
unshell1047113unshell
unslick1356023unslick
unsnag736393uns_nag
unsnap836203uns_nap
unspeaking1744423unspeaking
unsphere1355853unsphere
unspilt938853unspilt
unsplit956563unsplit
unspoke1336573unspoke
unspool945163unspool
unspun865793unsp_un
unstack1337373unstack
unsteady1243513unsteady
unsteel738793unsteel
unstep839223unste_p
unsteps936213unsteps
unstick1338123unstick
unstrap946783unstrap
unstuck1345023unstuck
unsunk1036333uns_unk
unswears1144023unswears
unswept1246013unswept
untread857413untread
usnea539393u_snea_
usneas638333u_sneas

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.403443402.0
2DLD Change Limit134027866.75019855.9
3Display Results86860.0165375.0
 (SQL Overall)178691867.16924925.5
 
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.