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

125 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
shoal8392027(None) 
sheal84927701sheal
shoals94215791shoals
shoaly124010771shoaly
shoat85633951shoat
shool84523151shool
shorl84720251shorl
skoal93811461skoal
chola104718032chola
choral115118492choral
coal66939252_coal
dhal86719282dh_al
foal76630922_foal
ghoul959052ghoul
goal55829302_goal
heal75645692_heal
hoar76729162_hoar
hoax147718292_hoax
horal86328682_horal
howl107625692_howl
phial10313202phial
phonal11310382phonal
sabal75422482sabal
sal36462882s__al
salal55425702salal
school11410722school
schorl1179812schorl
scowl1012012972scowl
seal45654372s_eal
sepal77723002sepal
seral56336382seral
setal56430902setal
sha69837782sh_a_
shad86230912sh_ad
shag86430562sh_ag
shah105627782sh_ah
shale85332832sh_ale
shall85024052shall
shalt85534492sh_alt
shaly114322862sh_aly
sham96436362sh_am
shat76456602sh_at
shaul85418102shaul
shaw108132552sh_aw
shawl116217572shawl
shay107133342sh_ay
shea76031572shea_
sheaf115424122sheaf
sheals94420642sheals
shear85424832shear
sheas86331792sheas
shell84424122shell
sheol84318372sheol
shiel811023772shiel
shill85325332shill
shoaled113810972shoaled
shoaler102610082shoaler
shoats94117082shoats
shock144917032shock
shod86225062sho_d
shoe75933442sho_e
shoed95723012shoed
shoer84722162shoer
shoes85429662shoes
shofar1236312shofar
shog86025142sho_g
shogi95014012shogi
shogs95319712shogs
shoji15419962shoji
shone83725982shone
shoo75929892sho_o
shook124920162shook
shools94919012shools
shoon84022012shoon
shoos84226362shoos
shoot84235912shoot
shop95629842sho_p
shops104222902shops
shoran94016042shoran
shore85432652shore
shorls94516202shorls
shorn85722182shorn
short85040532short
shot76150262sho_t
shote85526102shote
shots84730852shots
shott85332192shott
should1038032should
shout85433172shout
shove114421042shove
shovel124611322shovel
show106229192sho_w
shown115216482shown
shows115324582shows
showy145714012showy
shoyu1138912shoyu
shul75823152sh_ul
shwa106014962shwa_
shwas116415102shwas
sial45938832s_ial
sisal54217732sisal
skoals10438242skoals
snool55118642snool
soak87227662s_oak
soap65831132s_oap
soar46838672s_oar
soil46138832s_oil
sol37256622s_o_l
sola45541862s_ola
soul46435712s_oul
spoil75818652spoil
spool75219042spool
sporal82915452sporal
steal56125472steal
stoa45425912stoa_
stoae55024262stoae
stoai55417872stoai
stoas55126022stoas
stoat57135952stoat
stomal85213312stomal
stool55619892stool
sural55931262sural
wheal115716182wheal
whoa106615202whoa_
whorl114612452whorl

Search took 3 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.310576422.6
2DLD Change Limit538001251.64332745.0
3Display Results1251250.0304166.7
 (SQL Overall)1786911251.98390111.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.