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

90 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
shroffed184256(None) 
scoffed16266182s_coffed
seriffed1594972seriffed
shroff1538502shroff__
shroffs1634362shroff_s
shrouded1333602shrouded
boffed15369483__boffed
chaffed19387703ch_affed
cheffed19335863ch_effed
chromed153510923chro_med
chuffed19316643ch_uffed
doffed14428503__doffed
feoffed1332813_feoffed
gruffed1544943_gruffed
hoofed134614893_h_oofed
huffed163710153_h_uffed
offed12359163___offed
proffer15126933_proffer
proofed13138723_proofed
reffed134712513__reffed
reroofed1235873reroofed
riffed133811563__riffed
rolfed104510523__rolfed
roofed105214743__roofed
ruffed134312743__ruffed
sclaffed17102673sclaffed
scoffer15317023s_coffer
scrolled1137053scrolled
scrooped1356403scrooped
scrouged1235383scrouged
scuffed16298243s_cuffed
serifed11811463ser_ifed
shafted14288813sh_afted
sheafed14388973sh_eafed
sheetfed1544143sheetfed
shifted14359983sh_ifted
shmoozed23254363shmoozed
shoaled113810973sh_oaled
shocked174611813sh_ocked
shoed95723013sh_o__ed
shogged13397963sh_ogged
shooed103916083sh_o_oed
shooled115212663sh_ooled
shopped153512213sh_opped
shored105723653sh_o_red
shorted113614403sh_orted
shotted113912403sh_otted
shouted113911553sh_outed
shoved134214283sh_o_ved
showed135016973sh_o_wed
shred98125613shr___ed
shredded1444063shredded
shrewed14589843shr_ewed
shrieked16265173shrieked
shrieved15276073shrieved
shrilled1246863shrilled
shrimped1634213shrimped
shrined114112413shr_ined
shrived144712183shr_ived
shroffing1943313shroffing
shroud1038773shro__ud
shrove125412233shro_ve_
shrugged1433673shrugged
shuffled18296243shuffled
sluffed14308303s_luffed
sniffed14318183s_niffed
snuffed14308073s_nuffed
spiffed16257103s_piffed
spoofed13399103s_poofed
sprouted1136393sprouted
squiffed2433733squiffed
staffed14298283s_taffed
stiffed14359583s_tiffed
strafed114413333str_afed
stroked124613623stro_ked
strolled937813strolled
stropped1367343stropped
strowed115312143stro_wed
stroyed114110863stro_yed
stuffed14328973s_tuffed
surfed103814463sur__fed
tariffed1533723tariffed
throated1247923throated
throbbed1643163throbbed
throned115412173thro_ned
thronged13405333thronged
troffer13125863_troffer
unroofed12106773unroofed
whiffed2064473wh_iffed
whoofed17374513wh_oofed

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.420425454.8
2DLD Change Limit146162908.06318127.5
3Display Results90900.0631428.6
 (SQL Overall)178691908.54620909.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.