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

80 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
schticks1919395(None) 
schtick18194521schtick_
schtiks16184741schti_ks
shticks16356961s_hticks
chicks175317592_ch_icks
schlocks19245692schlocks
schmucks2142762schmucks
schriks16185742schri_ks
schtik15185422schti_k_
shtick15308022s_htick_
shticky19344472s_hticky
shtiks13297832s_hti_ks
sticks125118612s__ticks
anticks134612253_anticks
ascetics1247073ascetic_s
bedticks1774163bedticks
checks174912703_ch_ecks
chicas135916473_ch_icas
chick165419133_ch_ick_
chicos134614833_ch_icos
chics123920943_ch_ic_s
chinks155817573_ch_inks
chirks155414843_ch_irks
chocks174815313_ch_ocks
choices142010613_choices
chucks174812933_ch_ucks
clicks145315113_c_licks
cricks144316053_c_ricks
deticks1437353_deticks
hicks145322173__h_icks
hoicks15378283__hoicks
scatbacks1974713scatbacks
scenics1137773scenic_s
sceptics1455663sceptic_s
schisms1437173sch_isms
schists1248543sch_ists
schizos21115433sch_izos
schlock18235873schlock_
schlocky22243383schlocky
schmuck2043043schmuck_
schnecke1942603schnecke
schnooks1754243schnooks
schrik15206703schri_k_
schuits1235823schui_ts
sciaticas13104823sciaticas
sciatics12117273sciatic_s
scolices1238733scolices
scotias939753scoti_as
scraichs1543993scraichs
septics112810433septic_s
shacks154817563s_h_acks
sheiks132510013s_hei_ks
shicksa1634103s_h_icksa
shirks134814123s_h_irks
shlocks16317183s_hlocks
shmucks1833943s_hmucks
shocks154414583s_h_ocks
shrieks14377673s_hrieks
shrinks14397913s_hrinks
shtik123210963s_hti_k_
shucks154010413s_h_ucks
sicks115127623s___icks
slicks124816113s__licks
snicks124312473s__nicks
spicks144814993s__picks
stacks124317263s__tacks
statices102712343statices
staticky1743233staticky
statics93314533static_s
stichs114511653s__tichs
stick115121563s__tick_
sticky154711343s__ticky
stinks105616833s__tinks
stirks104914243s__tirks
stocks124715633s__tocks
stricks134310693s_tricks
thicks154511993_th_icks
ticks115823293___ticks
unsticks1436233unsticks
upticks1535153_upticks

Search took 7 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 Filter1786911461620.423422437.4
2DLD Change Limit146162806.31323152.5
3Display Results80800.0302666.7
 (SQL Overall)178691806.76626410.1
 
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.