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

50 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
peashooters165234(None) 
peashooter1552591peashooter_
crapshooters1992153crapshooters
peasoupers1492053peas_oupers
shooters112811583___shooters
snapshooters1761733snapshooters
trapshooters17102493trapshooters
assorters965734__assorters
beachgoers1842094beachgo_ers
crapshooter1872234crapshooter_
easters75125684_eas___ters
exhorters1944714_e_xhorters
fashioners16123964_fashioners
feasters11511564feas___ters
flashovers1952814flash_overs
gasholders1543804_gasholders
headhunters1852054headhunters
hooters104520474____hooters
leafhoppers2151434leafhoppers
leaseholders1652134leaseholders
parroters1156764p_a_rroters
passovers14144754p_as_sovers
pasters94531734p_as___ters
peachers153213844peach___ers
peasouper1382194peas_ouper_
penholders1643794pe_nholders
pensioners1245364pens_ioners
pensters103012124pens___ters
persisters1246274pers_isters
pesters93827094pe_s___ters
pewholders1942704pe_wholders
piasters102912814pias___ters
pinspotters1551834pinspotters
plashers133813454plash___ers
plasters103518134plas___ters
preschoolers1992094preschoolers
pushovers1743004p_ush_overs
pussyfooters206774pussyfooters
reasoners947114reas__oners
reshoots11228414re_shoot__s
reshowers15145474re_sh_owers
resorters939694re_s_orters
scooters103511034___scooters
seashores1247964seash_ore_s
seasoners946264seas__oners
sharpshooters2161394sharpshooters
shooter103013994___shooter_
shouters113510624___shouters
snapshooter1661804snapshooter_
trapshooter1682794trapshooter_

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 Filter1786911488190.420425454.8
2DLD Change Limit148819509.33015950.6
3Display Results50500.0163125.0
 (SQL Overall)178691509.76618297.3
 
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.