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

86 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
shroffing194331(None) 
scoffing17275942s_coffing
shrouding1434752shrouding
boffing16339983__boffing
chaffing2036323ch_affing
cheffing2034463ch_effing
chroming163410723chro_ming
chuffing2055043ch_uffing
coffing163811253__coffing
doffing15357793__doffing
feoffing1432963_feoffing
gruffing1635273_gruffing
hoofing143912553_h_oofing
huffing17278833_h_uffing
offing13368643___offing
proofing1439313_proofing
reffing143712173__reffing
reroofing1336863reroofing
riffing144011273__riffing
rolfing113710653__rolfing
roofing113814353__roofing
ruffing143210843__ruffing
sclaffing1843363sclaffing
scrolling12187803scrolling
scrooping1446593scrooping
scrouging1335263scrouging
scuffing17287113s_cuffing
shafting15278683sh_afting
sheafing15329483sh_eafing
shifting152910383sh_ifting
shmoozing2443613shmoozing
shoaling123111753sh_oaling
shocking184311543sh_ocking
shoeing113211883sh_o_eing
shogging14308023sh_ogging
shooing112112913sh_o_oing
shooling123012563sh_ooling
shooting122812863sh_ooting
shopping163611293sh_opping
shoring112820073sh_o_ring
shorting122514803sh_orting
shotting123012383sh_otting
shouting122711793sh_outing
shoving142910643sh_o_ving
showing143814663sh_o_wing
showring1548323sh_owring
shredding1544513shredding
shrewing15228093shr_ewing
shrieking1734583shrieking
shrieving1633973shrieving
shrilling13307693shrilling
shrimping1734063shrimping
shrining122610853shr_ining
shrinking1735653shrinking
shriving15268453shr_iving
shroff1538503shroff___
shroffed1842563shroff_ed
shroffs1634363shroff__s
shrugging1533703shrugging
shuffling1933453shuffling
sluffing15247303s_luffing
sniffing15227453s_niffing
snuffing15256803s_nuffing
spiffing17237083s_piffing
spoofing14228363s_poofing
sprouting1236943sprouting
staffing15247493s_taffing
stiffing15248703s_tiffing
strafing122111193str_afing
stroking132610943stro_king
strolling10238793strolling
stropping1436933stropping
strouding1136373strouding
strowing122310563stro_wing
stroying122410593stro_ying
stuffing15247843s_tuffing
surfing112914483sur__fing
tariffing1644113tariffing
throating1398403throating
throbbing1743533throbbing
thronging1435073thronging
throning1238863thro_ning
throwing1536723thro_wing
unroofing1385703unroofing
whiffing2134703wh_iffing
whoofing18234833wh_oofing

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 Filter1786911486410.486367677.0
2DLD Change Limit148641867.98318619.7
3Display Results86860.0302866.7
 (SQL Overall)178691868.49921024.9
 
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.