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

195 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
shicksa163410(None) 
shicksas1743521shicksas
shiksa1394651shi_ksa
chicks175317592chicks_
hicks145322172_hicks_
shacks154817562shacks_
shicker163914822shicker
shiksas1484642shi_ksas
shikse1386072shi_kse
shirks134814122shirks_
shocks154414582shocks_
shticks16356962shticks_
shucks154010412shucks_
sicks115127622s_icks_
slicks124816112slicks_
snicks124312472snicks_
spicks144814992spicks_
sticks125118612sticks_
thicks154511992thicks_
ahimsa1134783ahi_msa
bricks144614623bricks_
checks174912703checks_
chica125818263chic__a
chicas135916473chicas_
chicest14209943chicest
chick165419133chick__
chickee183111553chickee
chicken18278983chicken
chickpea2143193chickpea
chicos134614833chicos_
chics123920943chic_s_
chinks155817573chinks_
chirks155414843chirks_
chocks174815313chocks_
chucks174812933chucks_
clicks145315113clicks_
cricks144316053cricks_
dicks125824693_dicks_
flicks154512993flicks_
hacks144928713_hacks_
hacksaw1943713_hacksaw
hecks145220653_hecks_
hick135530303_hick__
hickey185011993_hickey
hickie153812473_hickie
hickish1936473_hickish
hocks144925493_hocks_
hoicks15378283hoicks_
hucks144322173_hucks_
kicks104420083_kicks_
klicks11468723klicks_
licks115325393_licks_
micks135525373_micks_
nicks114920493_nicks_
picks135226143_picks_
pricks144414263pricks_
quicks21389303quicks_
ricks115126133_ricks_
ricksha1643123_ricksha
sacks114228873s_acks_
saices84221803saices_
schticks19193953schticks_
shack145321753shack__
shacked174015393shacked
shackle16409543shackle
shacko153810113shack_o
shackos16429023shackos
shanks135315583shanks_
sharks135019723sharks_
sheiks132510013sheiks_
shiatsu1033433shiatsu
shickers173012823shickers
shiels95418923shiels_
shiers94921753shiers_
shies86136553shi_es_
shiest95821533shi_est
shifts124412943shifts_
shikar1336803shi_kar
shikker13277023shikker
shikseh17102603shi_kseh
shikses14116573shi_kses
shills94519613shills_
shims104422553shi_ms_
shines95028913shines_
shins85131043shi_ns_
ships105123773shi_ps_
shires95225573shires_
shirk124817843shirk__
shirked153710463shirked
shirker143711343shirker
shirrs94413173shirrs_
shirts94918343shirts_
shist84829613shi__st
shists96515113shists_
shits84731173shi_ts_
shiva115915003shi__va
shivas124512413shivas_
shives124921413shives_
shivs115018803shi_vs_
shlocks16317183shlocks_
shmucks1833943shmucks_
shock144917033shock__
shocked174611813shocked
shocker163411433shocker
shooks134515633shooks_
shrieks14377673shrieks_
shrinks14397913shrinks_
shtick15308023shtick__
shticky19344473shtick_y
shtiks13297833shtiks_
shuck144314533shuck__
shucked17389833shucked
shucker163710103shucker
sices75637273s_ices_
sick106435573s_ick__
sickbay1843723s_ickbay
sicked134524403s_icked
sickee124622223s_ickee
sicken124615253s_icken
sicker124023903s_icker
sickest131813793s_ickest
sickie123715743s_ickie
sickish1638423s_ickish
sickle124418323s_ickle
sickly153110483s_ickly
sicko115315393s_ick_o
sickos125112033s_ickos
sics65234093s_ic_s_
sika86021323s_i_k_a
sikas94617023s_i_kas
silks94620683s_ilks_
sinks95529183s_inks_
skinks94511653skinks_
slacks124416533slacks_
slices84022853slices_
slick115520523slick__
slicked144413843slicked
slicken13309293slicken
slicker133314533slicker
slickest14229253slickest
slickly1635853slickly
slinks104315153slinks_
smacks144112323smacks_
smirks124910123smirks_
smocks145710013smocks_
snacks124514553snacks_
snecks124410033snecks_
snick114416013snick__
snicked143811633snicked
snicker133012673snicker
socks114926083s_ocks_
specks144312703specks_
spica94717943spic__a
spicas104715823spicas_
spices104326033spices_
spick134519073spick__
spics94123243spic_s_
spicula11259293spicula
spiks114117473spi_ks_
stacks124317263stacks_
stichs114511653stichs_
stick115121563stick__
sticked144114633sticked
sticker133515883sticker
stickit1339463stickit
stickle132410973stickle
stickman1643943stickman
stickum1534823stickum
stickup1533853stickup
sticky154711343stick_y
stinks105616833stinks_
stirks104914243stirks_
stocks124715633stocks_
stricks134310693stricks_
sucks114523073s_ucks_
swinks134610653swinks_
thacks154311923thacks_
thick145613353thick__
thicken16317873thicken
thicker163611023thicker
thickest17337303thickest
thicket163213073thicket
thickish2044603thickish
thickly19415573thickly
thickset17257133thickset
thinks134613363thinks_
ticks115823293_ticks_
tricks125319013tricks_
tricksy16436583tricksy
whacks184610483whacks_
whicker19359773whicker
whisks16497353whisks_
wicks144619363_wicks_
wricks154610623wricks_
yoicks15375933yoicks_

Search took 10 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.470380193.6
2DLD Change Limit1340271958.36016031.9
3Display Results1951950.1401392.9
 (SQL Overall)1786911958.97019921.0
 
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.