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

104 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
tofus8641542(None) 
toffs116016721toffs
tofts84919241tofts
tofu76921331tofu_
tolus55024481tolus
tonus56324301tonus
torus54329761torus
boffs134915502boffs
bogus85616472bogus
bolus79125542bolus
bonus75324322bonus
coffs134916302coffs
conus76726532conus
doffs125614332doffs
doofus1036162doofus
dufus94010812dufus
focus105815882focus
hocus104715202hocus
locus74819992locus
lofts85518362lofts
lotus55718062lotus
modus85417202modus
momus96116112momus
nodus66315992nodus
nous46136982no_us
offs107117012_offs
onus45826812_onus
opus66420592_opus
poufs105616062poufs
sofas85320712sofas
softs85019232softs
solus54726982solus
sorus54527582sorus
sous46947212so_us
tabus74820922tabus
talus55423262talus
taus46342732t_aus
taxus125512482taxus
teffs115111732teffs
thous86017262thous
thus76721472t_hus
tiffs114414882tiffs
toads65621072toads
tods56141842to_ds
toeas55726422toeas
toes46956442to_es
toff105929902tof_f
toffy145310282toffy
toft77441652tof_t
togas67823002togas
togs57242432to_gs
togue64816302togue
togues76014242togues
toils54527492toils
toits55327472toits
tokes95234972tokes
tolas54532772tolas
toles55147132toles
tolls54728432tolls
tolu45529152tolu_
tombs97818732tombs
tomes76037382tomes
toms68343492to_ms
tones56048662tones
tongs65928462tongs
tons46553052to_ns
tools55325242tools
toons55027532toons
toots55331872toots
topes76941762topes
topful1136542topful
tophs105220052tophs
tophus115210362tophus
topis76025832topis
topos75726392topos
tops66248122to_ps
toque145113092toque
toques154612352toques
toras55540372toras
torcs75123762torcs
tores55352672tores
toros54336192toros
torous64319032torous
torrs53923562torrs
tors46157382to_rs
torts56138122torts
toss45637972to_ss
totes55139682totes
tots46654122to_ts
tour45530382to_ur
tours55325892tours
touse55430672to_use
tout46753822to_ut
touts54830392touts
towns86018882towns
tows78545552to_ws
toyos87519142toyos
toys78036342to_ys
tufas85314382tufas
tuffs115118262tuffs
tufts85713272tufts
tutus55214812tutus
woful1158172woful
yous76230652yo_us

Search took 2 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.0931921408.6
2DLD Change Limit538001041.65632487.9
3Display Results1041040.0303466.7
 (SQL Overall)1786911041.779100444.6
 
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.