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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

56 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
strick12481320(None) 
stick115121561st_ick
stricks134310691stricks
strict84821041strict
struck12489261struck
trick115420691_trick
astrict9614792astrict
brick134618152_brick
crick135118752_crick
ostrich1238662ostrich
prick134317502_prick
rick107334662__rick
shriek134211102shriek
shrink134511732shrink
shtick15308022shtick
sick106435582s__ick
slick115520522s_lick
snick114416012s_nick
spick134519072s_pick
stack114421692st_ack
steric8317062steric_
stich104117922st_ich
sticks125118612st_icks
sticky154711342st_icky
stink95122502st_ink
stirk95717412st_irk
stock114417562st_ock
stoic7317252stoic_
stoics8311112stoics
streak104613622streak
streek104111412streek
stria55723212stri_a
striae65422272striae
stricken1436892stricken
strickle1467792strickle
stride75420962stride
strife95318362strife
strike105619732strike
string75327562string
strip77524342stri_p
stripe85822442stripe
strips85719652strips
stript85222192stript
stripy115812742stripy
strive95020962strive
strook10410302strook
stuck114515772st_uck
thick145613352_thick
tick106231232_t_ick
track114823012_track
trice75127492_trice
tricks125319012_tricks
tricky154211472_tricky
trock114817602_trock
truck116115462_truck
wrick144013392_wrick

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 Filter178691825510.360496363.9
2DLD Change Limit82551562.51632810.4
3Display Results56560.0134307.7
 (SQL Overall)178691562.88961852.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.