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

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

127 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
toffs11601672(None) 
boffs134915501boffs
coffs134916301coffs
doffs125614331doffs
offs107117011_offs
teffs115111731teffs
tiffs114414881tiffs
toff105929901toff_
toffy145310281toffy
tofts84919241tofts
tofus86415421tofus
tuffs115118261tuffs
baffs134718052baffs
biffs134814412biffs
boff124727332boff_
boffo136010372boffo
boffos14568192boffos
buffs135519512buffs
caffs135417372caffs
coff126930782coff_
coifs105718702coifs
coofs105924712coofs
cuffs135017492cuffs
cutoffs1533602cutoffs
daffs125116422daffs
diffs126315482diffs
doff116225782doff_
duffs125216622duffs
effs105114032_effs
feoffs1163702feoffs
gaffs124914652gaffs
golfs95616102golfs
goofs94821002goofs
guffs124414822guffs
hoofs115721042hoofs
howffs18535042howffs
howfs144814502howfs
huffs144514742huffs
jiffs185710312jiffs
loafs85616992loafs
lofts85518362lofts
loofs85623782loofs
luffs114516282luffs
miffs134512882miffs
muffs134114212muffs
naffs116213962naffs
oafs76425262_oafs
off96331632_off_
poofs105222792poofs
pouffs14418122pouffs
poufs105616062poufs
puffs134114932puffs
putoffs1543332putoffs
raffs115017522raffs
riffs115114612riffs
rolfs84817122rolfs
roofs85321152roofs
ruffs114516742ruffs
scoffs14347502scoffs
setoffs1334132setoffs
sofas85320712sofas
softs85019232softs
staffs12349752staffs
stiffs12389962stiffs
stuffs123810222stuffs
taffy145110822taffy
teff106023762teff_
tiff104727722tiff_
tipoffs1543032tipoffs
toads65621072toads
tods56141842to_ds
toeas55726422toeas
toes46956442to_es
toffee123311012toffee
toffees13327082toffees
toffies133210212toffies
toft77441652to_ft
tofu76921332to_fu
togas67823002togas
togs57242432to_gs
toils54527492toils
toits55327472toits
tokes95234972tokes
tolas54532772tolas
toles55147132toles
tolls54728432tolls
tolus55024482tolus
tombs97818732tombs
tomes76037382tomes
toms68343492to_ms
tones56048662tones
tongs65928462tongs
tons46553052to_ns
tonus56324302tonus
tools55325242tools
toons55027532toons
toots55331872toots
topes76941762topes
tophs105220052tophs
topis76025832topis
topos75726392topos
tops66248122to_ps
toras55540372toras
torcs75123762torcs
tores55352672tores
toros54336192toros
torrs53923562torrs
tors46157382to_rs
torts56138122torts
torus54329762torus
toss45637972to_ss
totes55139682totes
tots46654122to_ts
tours55325892tours
touts54830392touts
towns86018882towns
tows78545552to_ws
toyos87519142toyos
toys78036342to_ys
tufas85314382tufas
tuff104528522tuff_
tufts85713272tufts
turfs84620442turfs
waffs146315472waffs
wolfs116214162wolfs
woofs114918002woofs
yaffs145311122yaffs

Search took 3 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 Filter178691538000.326548131.9
2DLD Change Limit538001271.64032804.9
3Display Results1271270.0333848.5
 (SQL Overall)1786911271.99989390.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.