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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

74 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
staffs1234975(None) 
staff113817711staff_
stiffs12389961stiffs
stuffs123810221stuffs
baffs134718052_baffs
blaffs14426622blaffs
caffs135417372_caffs
chaffs17459612chaffs
daffs125116422_daffs
distaffs1565082distaffs
draffs13617902draffs
gaffs124914652_gaffs
naffs116213962_naffs
quaffs21125692quaffs
raffs115017522_raffs
restaffs1444782restaffs
safes85226722s_afes
scarfs114714682scarfs
sclaffs1543572sclaffs
scoffs14347502scoffs
scuffs14419052scuffs
setoffs1334132setoffs
shafts125411442shafts
skiffs16327012skiffs
sluffs12349582sluffs
snafus936742snafus
snarfs95113422snarfs
sniffs12378842sniffs
snuffs12358532snuffs
spiffs14328472spiffs
stabs76221382sta_bs
stacks124317262stacks
stades74626242stades
staffed14298282staffed
staffer13299092staffer
staffers14247082staffers
stages75629492stages
stags66226742sta_gs
staigs75414812staigs
stains64923652stains
stairs65416332stairs
stakes103927292stakes
stales65538292stales
stalks104614552stalks
stalls64019932stalls
stamps105614022stamps
stands75118052stands
stanes64933402stanes
stangs75018172stangs
stanks104917702stanks
stapes85028732stapes
staphs114411032staphs
stares66038752stares
stars55836572sta_rs
starts65423122starts
stases64225562stases
stasis63116872stasis
states64337082states
stats55933362sta_ts
status65515212status
staves94525192staves
stays86022022sta_ys
stiff114219242stiff_
strafes104516002strafes
stuff113817052stuff_
stuffy15317082stuffy
swarfs125612062swarfs
taffy145110822_taffy
teffs115111732_teffs
tiffs114414882_tiffs
toffs116016722_toffs
tuffs115118262_tuffs
waffs146315472_waffs
yaffs145311122_yaffs

Search took 7 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 Filter178691825510.406440125.6
2DLD Change Limit82551746.11013510.8
3Display Results74740.0461608.7
 (SQL Overall)178691746.56227231.2
 
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.