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

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

122 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
putoff143642(None) 
cutoff1436561cutoff
putoffs1543331putoffs
buyoff1754232buyoff
cutoffs1533602cutoffs
dustoff1445052dustoff
payoff1736022payoff
puff125525432pu__ff
puton73617912puto_n
putons83515152putons
putout8315112putout
ruboff1435202ruboff
runoff1235412runoff
setoff1238912setoff
shutoff1693202shutoff
toff105929902__toff
auto47432083auto__
autoed7712823autoed
autos56523323auto_s
boff124727333__boff
buff125229863bu__ff
buyoffs1842433buyoffs
castoff1547793castoff
coff126930783__coff
cuff125327993cu__ff
cutout8315923cutout
dieoff1335503dieoff
doff116225783__doff
duff114326643du__ff
dustoffs1543163dustoffs
feoff10711053_feoff
flyoff1444023flyoff
fuckoff1842393fuckoff
futon83113773futo_n
futons93911513futons
guff114624933gu__ff
huff135623843hu__ff
jumpoff2442243jumpoff
layoff1545093layoff
liftoff1243163liftoff
luff104426703lu__ff
muff124723863mu__ff
muton73817003muto_n
mutons84314363mutons
off96331633___off
outfox1636143outfox
patois84319363patois
payoffs1843243payoffs
pickoff2143693pickoff
pilaff143910363pilaff
piton76121583pito_n
pitons85319043pitons
playoff1843533playoff
pluton838853pluto_n
plutons938343plutons
pontiff1547903pontiff
poof95541663p__oof
poofs105222793p_oofs
poofy136213273p_oofy
pouf95732643p__ouf
pouff135215423p_ouff
prof96134663p_ro_f
profs105120893p_rofs
proof105221533p_roof
proofs114511683proofs
prutot8311823pruto_t
prutoth1243473prutoth
puffs134114933pu_ffs
puffy164410753pu_ffy
punto75121323punto__
puntos85915793punto_s
purify14399153purify
put55759073put___
putdown1343883putdown
putlog965553putlog
putlogs1065083putlogs
putouts937083putouts
putrefy1543313putrefy
putrid9311173putrid
puts65641753put__s
putsch1334933putsch
putt66937843put__t
putted94220253putted
puttee85919723puttee
putter83921443putter
putti76018743put_ti
puttie84116303puttie
putto75617663put_to
putts75719273put_ts
putty104721403put_ty
putz158326323put__z
putzed18409113putzed
putzes174212523putzes
quaff201311353qu_aff
quiff201111563qu_iff
ripoff1436433ripoff
ruboffs1543123ruboffs
ruff105127653ru__ff
runoffs1343013runoffs
scoff134413343_scoff
setoffs1334133setoffs
shroff1538503shroff
shutoffs1752073shutoffs
spinoff1544933spinoff
staff113817713_staff
stiff114219243_stiff
stuff113817053_stuff
teff106023763__teff
tiff104727723__tiff
tipoff1436383tipoff
toffs116016723__toffs
toffy145310283__toffy
toft77441653__toft
tofu76921333__tofu
tuff104528523__tuff
turnoff1344013turnoff
tutor5712493tuto_r
tutors6912333tutors
uptore8279453uptore
uptorn8268093uptorn
uptoss836093uptoss
uptown11274963uptown

Search took 6 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 Filter1786911127160.373479064.3
2DLD Change Limit1127161225.44020719.9
3Display Results1221220.0462652.2
 (SQL Overall)1786911225.85930498.5
 
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.