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

65 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
restuffs144419(None) 
restaffs1444771restaffs
restuff1346951restuff_
dyestuffs1951322dyestuffs
rebuffs1533402re_buffs
restaff1339002restaff_
restuffed1663322restuffed
stuffs123810222__stuffs
bestuds10326753bestu_ds
breadstuffs2061023breadstuffs
castoffs1644043castoffs
cestus84412913cestu__s
cestuses1038083cestuses
distaffs1565073distaffs
dustoffs1543163dustoffs
dyestuff1852253dyestuff_
feedstuffs1651043feedstuffs
gestures9310013gestures
greenstuffs1891113greenstuffs
mastiffs1644233mastiffs
overstuffs1942363overstuffs
rebuff1437023re_buff_
rectums11338523rectu_ms
rectus83314633rectu__s
rescuers1037363rescuers
rescues9312753rescu_es
reshuffle1851933reshuffle
reshuffles1951873reshuffles
resifts10378703res_ifts
resounds956483resounds
restacks1438093restacks
restaffed1653743restaffed
restages92815763restages
restamps1234703restamps
restarts8310873restarts
restates83423413restates
resters74130403rest_ers
restful1038613rest_ful
restless82713163restless
restocks1437503restocks
restokes125213043restokes
restores85222983restores
restress82511773restress
rests54935873rest___s
restudies10156033restudies
restudy1144763restu_dy
restuffing1743163restuffing
restyles1139193restyles
results739833res_ults
resumes9313373res_umes
retunes76918403re_tunes
returns79712593re_turns
ruffs114516743r___uffs
scuffs14419053__scuffs
setoffs1334133se_toffs
sluffs12349583__sluffs
snuffs12358523__snuffs
staffs12349753__staffs
stiffs12389963__stiffs
stuff113817053__stuff_
stuffy15317083__stuffy
testudos943053testudos
tuffs115118263___tuffs
unstuffy1761673unstuffy
vestures11311033vestures

Search took 8 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.220812231.8
2DLD Change Limit146162657.73318901.1
3Display Results65650.0302166.7
 (SQL Overall)178691657.98322383.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.