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

47 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
ripstops126501(None) 
ripstop1174761ripstop_
misstops12176412misstops
tiptops1136072tip_tops
aristos7312373ari_sto_s
bishops1437033bi_shops
bristols1046773bri_stols
dipsos95310053dips_o_s
dripstone1244153dripstone
dripstones1343933dripstones
estops84011223__estops
hightops1745043hightops
hilltops1344933hilltops
hipsters13268793hipsters
insteps936573_insteps
laptops1166603lap_tops
missteps12156143missteps
misstop11156413misstop_
nonstops10116883nonstops
pistols93213983pi_stols
pistons93016373pi_stons
pistous92714383pi_stous
postops11311713_postops
psyops1334343__psyops
ragtops1035453r_agtops
raptors94213353rap_tors
redtops1037373r_edtops
rialtos736613rialto_s
ridgetops1342193ridgetops
rimshots1343883rimshots
ringtoss944203ringtoss
riotous739863ri_otous
ripostes10239083ripost_es
riposts9279403ripost__s
ripraps1134943rip_raps
ripsaws1243823rips_aws
ristras7311563ri_stras
rooftops13152913rooftops
slipslops1351963slipslops
stops74827283___stops
tipsters10278513tipsters
tipstock1643733tipstock
tipstocks1743423tipstocks
tiptoes939173tip_toes
tiptop1036103tip_top_
unstops936993_unstops
upsteps1133743_upsteps

Search took 9 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.406440125.6
2DLD Change Limit146162477.61019206.6
3Display Results47470.0162937.5
 (SQL Overall)178691478.03222247.4
 
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.