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

160 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
off9633163(None) 
aff95537611aff
boff124727331boff
coff126930781coff
doff116225781doff
eff96128621eff
iff96730391iff
oaf65952881oaf
of58247771o_f
offs107117011offs
oft67744061oft
toff105929901toff
aft66849012aft
arf67453372arf
baff124632272baff
biff125026892biff
boffo136010372boffo
boffs134915502boffs
buff125229862buff
caff125631672caff
coffs134916302coffs
coft97939682coft
coif96337912coif
coof96643272coof
corf95941482corf
cuff125327992cuff
daff115229682daff
def76546722def
dif76846902dif
diff116228842diff
doffs125614332doffs
duff114326642duff
ef57345362_ef
effs105114032effs
efs66829602efs
eft66038822eft
elf66138522elf
fa510148452_fa
fe57944742_fe
feoff10711052feoff
fob86748332fob
foe66350812foe
fog76945562fog
foh98135892foh
fon66352272fon
fop86743702fop
for66952072for
fou66743782fou
fox136737862fox
foy96044262foy
gaff114828152gaff
golf85731182golf
goof85436872goof
guff114624932guff
hoof106036582hoof
howf136127202howf
howff175110492howff
huff135623842huff
if57239952_if
iffy135312282iffy
ifs67124242ifs
jiff175321412jiff
kaf106845512kaf
kef105639662kef
kif105941182kif
loaf76734902loaf
loft76539142loft
loof78141052loof
luff104426702luff
miff125625062miff
muff124723862muff
naff105128932naff
oafs76425262oafs
oak76238652oak
oar37057952oar
oat39888262oat
oba57531552oba
obe56638642obe
obi57127732obi
oca56731732oca
od39255242o_d
oda48133042oda
odd57725452odd
ode47446582ode
ods47546212ods
oe28473062o_e
oes35866192oes
ofay106416102ofay
offal1136242offal
offed12359162offed
offer114311382offer
oh57447002o_h
ohm86523012ohm
oho66534382oho
ohs66232312ohs
oi29061482o_i
oil37452052oil
oka76926802oka
oke75839482oke
old47033462old
ole37155212ole
om48553002o_m
oms56337512oms
on28057182o_n
one37050912one
ono36838032ono
ons36148512ons
ooh67637092ooh
oot311274692oot
op45850162o_p
ope56845242ope
ops56641252ops
opt57545542opt
or27354732o_r
ora37250832ora
orb55736862orb
orc57034922orc
ore36661832ore
ors35750112ors
ort39465232ort
os211359882o_s
ose38147342ose
oud47439072oud
our36042892our
out38072152out
ova66823792ova
ow58950172o_w
owe67041032owe
owl66228972owl
own66429702own
ox98242382o_x
oxo107322962oxo
oxy136320982oxy
oy58950132o_y
pfft12311882pfft
poof95541662poof
pouf95732642pouf
pouff135215422pouff
puff125525432puff
raff104933042raff
ref66053292ref
rif65951562rif
riff104430102riff
rolf75134872rolf
roof75738832roof
ruff105127652ruff
scoff134413342scoff
sofa75625602sofa
soft76942822soft
teff106023762teff
tiff104727722tiff
toffs116016722toffs
toffy145310282toffy
toft77441652toft
tofu76921332tofu
tuff104528522tuff
waff134228042waff
wolf105729562wolf
woof106532422woof
yaff135324262yaff

Search took 1 second 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 Filter178691140840.0632836365.1
2DLD Change Limit140841600.43632302.8
3Display Results1601600.0305333.3
 (SQL Overall)1786911600.529337790.2
 
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.