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

164 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
owse7632162(None) 
bowse105420631bowse
dowse96020811dowse
lowse87219901lowse
ose38147341o_se
owe67041031ow_e
owes75137101owes
owsen84210191owsen
apse67725382apse
arse46539272arse
awe67746622aw_e
awee76336642awee
awes76037552awes
base64847022base
bise66437092bise
bouse75931852bouse
bows96242862bows_
bowsed125715972bowsed
bowses115718862bowses
browse115713852browse
case65848082case
chowse144711752chowse
copse95623922copse
corse75036182corse
cows97046642cows_
dose56442432dose
douse66329722douse
dowie94721142dowie
dows85941052dows_
dowsed115015012dowsed
dowser104716082dowser
dowses105718302dowses
drowse105010552drowse
ease45042332ease
else45923082else
ewe66630982ew_e
ewes76328702ewes
fosse86119462fosse
fuse76429992fuse
goose65925902goose
gorse65926812gorse
hawse116015122hawse
hoise85224772hoise
horse86132652horse
hose76547242hose
house89131422house
howe106734102how_e
howes114730262howes
hows106345602hows_
jows146632092jows_
lase46148512lase
loose56627682loose
lose45144582lose
louse56131012louse
lowe75435312low_e
lowes85732462lowes
lows75843012lows_
lyse76320592lyse
mise66043572mise
moose76327192moose
morse76032702morse
mouse77133002mouse
mows96340832mows_
muse67136032muse
noise55723732noise
noose55624062noose
nose46739362nose
nowise9511072nowise
nows75738232nows_
oases55330982oases
oast47156322oast
obe56638642o_be
obes66036832obes
obese75212422obese
oboe66822942oboe
ode47446582o_de
odes57243242odes
ods47546212ods_
oe28473062o__e
oes35866192oes_
ogee57629882ogee
ogle56325052ogle
ogre56320742ogre
ohs66232312ohs_
oke75839482o_ke
okes84936342okes
ole37155212o_le
oles46453472oles
oms56337512oms_
once65423082once
one37050912o_ne
ones46146532ones
ons36148512ons_
onset54730172onset
ooze136420602ooze
ope56845242o_pe
opes65942612opes
ops56641252ops_
ore36661832o_re
ores46056682ores
orle45630462orle
ors35750112ors_
os211359882o_s_
oses46641512o_ses
ossa43714162ossa
ousel55222402ousel
oust46747442oust
ow58950172ow__
owed86833872owed
owl66228972ow_l
owlet83324462owlet
owls76022932owls
own66429702ow_n
owned95113232owned
owner84613312owner
owns76819582owns
oxes116530722oxes
oyes74940132oyes
pase65346862pase
poise75127892poise
pose66441732pose
posse74722272posse
pows95537662pows_
rase46149982rase
rise45945232rise
roose56127092roose
rose46148902rose
rouse56634702rouse
rows75941752rows_
ruse45938932ruse
souse56530772souse
sows75342492sows_
tawse85616502tawse
torse55833332torse
touse55430672touse
towie85821872towie
tows78545552tows_
twae74719572twae
twee76827082twee
use36835162_use
vase75629652vase
vise75632672vise
vows106626942vows_
wae67556952_wae
we57043452_w_e
wee66760812_wee
wise75737342wise
woe66651242_woe
woes76440662woes
woke115527962woke
wore77144672wore
worse86525262worse
wos66953532wos_
wost76544362wost
wove105624312wove
wows104633492wows_
wowser125110202wowser
wye96331972_wye
youse85322232youse
yowe106728742yow_e
yowes114926372yowes
yowie114616452yowie
yows106433122yows_
zowie174313842zowie

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 Filter178691298720.1401276364.3
2DLD Change Limit298721641.26623595.6
3Display Results1641640.0463565.2
 (SQL Overall)1786911641.452123065.4
 
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.