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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

109 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
summand123626(None) 
summands1344711summands
command14399212command
summa94713312summa__
summae103911012summa_e
summary14297352summary
summas104313162summa_s
summate113611662summate
summated13298832summated
summed114014042summ_ed
summing122912382summing
summon1037622summon_
summoned1345722summoned
summons1158002summons
sunland837472sunland
armband1265983armband
bummalo1353793bummalo
bummed134211723bumm_ed
bumming143410783bumming
busman10310253busman_
commando15275753commando
commands15318823commands
commend144010183commend
cummin1288783cummin_
cummins1358963cummins
demand104314253_demand
dummied13346723dummied
gormand1157453gormand
gourmand1243263gourmand
gumma105313103gumma__
gummas114810513gumma_s
gummata1244613gummata
gummed123811663gumm_ed
gumming133810193gumming
gunman9299453gunman_
human102716033hu_man_
humane112812173hu_mane
humans112312433hu_mans
hummed144812673humm_ed
humming153310673humming
husband1345653husband
immane1038883_immane
mummed104411553mumm_ed
mummied11327103mummied
mumming114010023mumming
nummary14314653nummary
outland81212343outland
outman83115033outman_
outmans92413283outmans
remand95618963_remand
rimland1035663rimland
rumbaed12287493rumbaed
rummage1234583rummage
rummaged1443273rummaged
sambaed1238303sambaed
sampan102511893sampan_
sampans112411003sampans
sand55338473s___and
scummed14347913scumm_ed
scumming15256793scumming
seaman84015903seaman_
shaman113314283shaman_
shamans123610903shamans
siamang1045333siamang
simian8811163simian_
simians959203simians
skyman1535313skyman_
slummed12359273slumm_ed
slumming13278383slumming
socman1039813socman_
soland75115043s_oland
soman75024903s_oman_
somans84619303s_omans
stand65923283s__tand
strand74514823s_trand
stummed12348553stumm_ed
stumming13347673stumming
submenu1148363submenu
subtend1037103subtend
suldan72611043suldan_
suldans8299723suldans
sultan63012593sultan_
sultana7257803sultana
sultans72411833sultans
sumac99514883su_ma_c
sumach135310113su_mach
sumacs105512103su_macs
summable1436903summable
summates122610493summates
summating1437943summating
summer104017713summ_er
summered1338143summered
summers113616503summers
summery14329413summery
summit10311543summ_it
summited13246413summited
summits1137983summits
summoner1245533summoner
summonsed1443303summonsed
sunlands936383sunlands
suntan62613003suntan_
suntans72111733suntans
sunward1137653sunward
surfman1236203surfman_
suspend1036013suspend
unhand10410383_unhand
unman72715423_unman_
unmans82211993_unmans
upland938863_upland

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 Filter1786911340270.390458182.1
2DLD Change Limit1340271097.61017612.0
3Display Results1091090.0462369.6
 (SQL Overall)1786911098.04622208.7
 
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.