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

58 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
scrimmagers185154(None) 
scrimmager1751911scrimmager_
scrimmages1742351scrimmage_s
scrimmage1642262scrimmage__
scrimmaged1851662scrimmage_d
scrummages1752052scrummage_s
crimmers14298543_crimm__ers
rummagers1443033__rummagers
scrimmaging1951253scrimmaging
scrimpers1554643scri_m_pers
scrummage1641873scrummage__
scrummaged1851523scrummage_d
brimmers14287074_brimm__ers
brummagems165744_brummagems
crammers14369354_cramm__ers
cribbages1642764_cribbage_s
crimmer133310774_crimm__er_
crimpers14318934_cri_m_pers
cringers112511874_cri__ngers
grimacers1463554_gri_macers
imagers10107764___i_magers
krimmers16315674_krimm__ers
primages13159274_pri_mage_s
rampagers1443864__rampagers
rimmers113812884__rimm__ers
rummager1343594__rummager_
rummages1344934__rummage_s
sailmakers1643784s_ailmakers
scammers14339774sc_amm__ers
scaremongers1751964scaremongers
scimiters1345124sc_i_miters
scramblers16183544scr_amblers
scrapers125510534scr___apers
scrappages1742434scrappage_s
screamers13236264scr__eamers
scribblers16183104scri_bblers
scribers12307964scri___bers
scrimper1455764scri_m_per_
scrimpier1554244scri_mpier_
scrimshanders216554scrimshanders
scripters13116684scri__pters
scriveners1543144scri_veners
scroungers1343184scr_oungers
scrummaging1951144scrummaging
scummers14277784sc_umm__ers
shimmers15269414s_himm__ers
shirtmakers2052204shirtmakers
shrimpers1633814shri_m_pers
shrinkages1842014shrinkage_s
simmers113314614s__imm__ers
skimmers16296464s_kimm__ers
slimmers12369634s_limm__ers
spriggers13325494spri__ggers
springers12309984spri__ngers
stringers104210644stri__ngers
strummers1333694strumm__ers
swimmers15276694s_wimm__ers
trimmers12288914_trimm__ers

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 Filter1786911488190.436409841.7
2DLD Change Limit148819588.33017865.4
3Display Results58580.0301933.3
 (SQL Overall)178691588.79620315.0
 
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.