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

98 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
seasick134619(None) 
seacock1545572seacock
seaside839692seaside
sebasic1146892sebasic_
airsick1395333airsick
basic96220523_basic_
basics104915123_basics
bedtick1645233bedtick
carsick1536343carsick
ceasing104118263ceasing
deasil71110983deasi_l
derrick1435803derrick
detick1339383de_tick
easier64218463_easier
easies64126633_easies
easily9313023_easily
easing74926463_easing
feasing113916653feasing
felsic1147053felsic_
fossick16134733fossick
heartsick1842483heartsick
leasing83920163leasing
medick154010133me_dick
mesic93617863me_sic_
musick14408703_musick
oversick1736983oversick
peacock1745143peacock
phasic133612053phasic_
sack105337313s_a__ck
saice75424053s_a_ice
salic73424713s_alic_
sasin54626573s_asi_n
sasins64923103s_asins
schtick18194523schtick
seabird1055363seabird
seacocks1645643seacocks
seagirt8310153seagirt
sealift10312793sealift
sealing83528563sealing
seamark1336723seamark
seamier93114633seamier
seaming103222113seaming
seance83716693sea_nce
seapiece1244373seapiece
search113312423sea_rch
searing83330923searing
seas45755273seas___
seasides938743seasides
season62714903seas_on
seasons72614233seasons
seatback1675823seatback
seating84130683seating
sebacic1346393sebacic_
seisin63715123seisi_n
seising84018863seising
seisins73614393seisins
seismic1145753seismic_
sematic111716883sematic_
sensing84116953sensing
sepic94617053se_pic_
sepsis83011293sepsi_s
septic102713193septic_
septics112810433septics
service1239093service
sessile739523sessile
session739763session
setback1567143setback
shack145321753sha__ck
shashlick2151553shashlick
shaslik1444513shaslik
shtick15308023s_htick
sialic8313633sialic_
sick106435573___sick
slack115021763sla__ck
slapstick1742863slapstick
slick115520523s__lick
smack134615453sma__ck
snack114718063sna__ck
snick114416013s__nick
spastic11310383spastic_
spastics1237503spastics
spick134519073s__pick
stack114421693sta__ck
stasima955633stasima
stasis63116873stasi_s
static83118683static_
statice92614033statice
staticky1743233staticky
statics93314533statics
stearic939423stearic_
stick115121563s__tick
strick124813203s_trick
suasion739363suasion
suasive1037853suasive
swastica1384153swastica
teasing83918513teasing
vesica11157913ve_sica
waesuck1643093waesuck

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 Limit134027986.98619185.1
3Display Results98980.0462130.4
 (SQL Overall)178691987.43524033.8
 
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.