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

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

52 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
kickstarts155200(None) 
kickstart1453831kickstart_
kickstands1652102kickstands
kickstarted1751352kickstarted
kickboards1843353kickboards
kickshaws2052223kicksha_ws
kickstand1552693kicksta_nd
kickstarting1851153kickstarting
misstarts1145833mi_sstarts
backseats1746674backsea_ts
backstabs1945474backsta_bs
backstages1945014backstages
backstairs1844474backstairs
backstamps2243254backstamps
backstays2045654backsta_ys
bistorts10118814bi__storts
costards113510794__costards
costars94218014__costar_s
custards11338394__custards
diktats1235624di_k_ta_ts
disparts11109954di__sparts
distorts91112354di__storts
hucksters1843654huckster_s
inkstands1443194_inkstands
instants8910154_i_nstants
instars7411134_i_nstar_s
jackshafts2952254jackshafts
jackstays2543004jacksta_ys
jackstraws2651944jackstraws
jockstraps2551534jockstraps
kickbacks1744314kick_backs
kickballs1643334kick_balls
kickboard1743824kickboar_d
kickers124013294kick__er_s
kickshaw1942364kicksha__w
kiesters123310154ki_ester_s
kismats13257844ki__sma_ts
lickspits1742504licks_pits
misparts12108174mi__sparts
misstart10410044mi_sstart_
outstarts9176324_outstarts
picketers17196484picketer_s
redstarts1044244_redstarts
restarts8310874__restarts
rickshas1743844ricksha__s
rickshaws2142614ricksha_ws
rockshafts2251844rockshafts
slicksters1643384slickster_s
starts65423124____starts
ticktacks1643394tick_tacks
tricksters16264764trickster_s
upstarts10165274__upstarts

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 Filter1786911614500.440406115.9
2DLD Change Limit161450529.22017510.8
3Display Results52520.0134000.0
 (SQL Overall)178691529.67318473.2
 
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.