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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

128 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
whale11551743(None) 
hale76052831_hale
shale85332831shale
wale74546431w_ale
whaled134612031whaled
whaler124611971whaler
whales124716941whales
while115418691while
whole114418091whole
ale36572342__ale
awhile1257792awhile
bale66353842_bale
chafe135117352chafe
chaleh143711992chaleh
chalet113825992chalet
chalk144814602chalk
chape125221142chape
chare105231982chare
chase105127122chase
chile105626892chile
chyle134913482chyle
dale55643982_dale
dhal86719282dhal_
dhals95415442dhals
dhole95215362dhole
exhale1636872exhale
gale56347322_gale
hade85440192_hade
hae67364002_ha_e
hake115637842_hake
haled95335822_haled
haler85033522_haler
hales85449842_hales
half106238452_half
hall75741162_hall
halm95834972_halm
halo76437322_halo
halt76056302_halt
halve114818922_halve
hame97043132_hame
haole84820082_haole
hare76255732_hare
hate78450172_hate
have106137072_have
haze164833392_haze
hole77553392_hole
inhale9411512inhale
kale86533752_kale
male66052292_male
pale66055012_pale
phage115113672phage
phase104617212phase
phyle134111152phyle
quale143617852quale
rale45050562_rale
sale44959702_sale
scale74629142scale
shade95125582shade
shake124726402shake
shaled105023952shaled
shales94731252shales
shaley123714992shaley
shall85024052shall
shalt85534482shalt
shaly114322862shaly
shame105726702shame
shape105125112shape
share86437082share
shave114425892shave
spale74929212spale
stale55637102stale
swale85221592swale
tale46154162_tale
thae76825562tha_e
thaler94613102thaler
thane86122532thane
thole85620842thole
vale74937342_vale
wade85237062w_ade
wae67556952w_a_e
wage84834082w_age
wake114935702w_ake
waled94330992w_aled
waler84229262w_aler
wales86142832w_ales
walk115625612w_alk
wall76236102w_all
waly105830902w_aly
wame95035482w_ame
wane76344712w_ane
ware76254722w_are
wave105234732w_ave
weal75838682weal_
weald95615022weald
weals85428742weals
weave115218532weave
wha96422072wha__
whack174813022whack
whalers13529702whalers
wham125321692wha_m
whamo135511262whamo
whams135515642whams
whang124813382whang
whap125119642wha_p
whaps135115162whaps
wharf14315822wharf
wharve15456202wharve
what105434072wha_t
whats117718992whats
whaup13458882whaup
wheal115716182wheal_
wheals124512522wheals
whee105429592wh_ee
wheel115515332wheel
whelk154311062whelk
whelm134611982whelm
whelp136012092whelp
where117019422where
whiled134514132whiled
whiles124418012whiles
whine116022812whine
white114920302white
wholes124616772wholes
whore116018042whore
whose114914532whose
wile75944372w_ile
woald94813072woald
wyle105519382w_yle

Search took 5 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 Filter178691538000.186960704.3
2DLD Change Limit538001283.62314849.6
3Display Results1281280.0801600.0
 (SQL Overall)1786911283.88945947.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.