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

120 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
dhows12591122(None) 
chows135618201chows
dhow116614001dhow_
dows85941051d_ows
hows106345601_hows
shows115324581shows
avows114910982avows
blows105423832blows
bows96242862_bows
brows105425982brows
cahows14399122cahows
chaws135022462chaws
chews135418512chews
chops125019872chops
chow125820992chow_
chowse144711752chowse
cows97046642_cows
crows105727312crows
daws86638242d_aws
dews86230602d_ews
dhaks13479702dhaks
dhals95415442dhals
dhobi1136972dhobi
dhobis1236112dhobis
dhole95215362dhole
dholes104914792dholes
dhoti9310122dhoti
dhotis1038972dhotis
diols65521012diols
docs75631152d_ocs
does56554472d_oes
dogs66440152d_ogs
dols56943052d_ols
doms76239572d_oms
dons56048702d_ons
dooms85321342dooms
doors65022132doors
dors56747602d_ors
dos48062312d_o_s
doss56235042d_oss
dots55647662d_ots
dow76749972d_ow_
down86427492d_own
downs94918572d_owns
dowse96020812d_owse
draws95119372draws
drops85719502drops
dross65418092dross
drown95515822drown
drowns105612332drowns
drowse105010552drowse
drowsy13487902drowsy
duos56728132duo_s
enows85115492enows
flows115822362flows
frows116623102frows
glows95518032glows
grows95523922grows
haws106439442_haws
hews105631572_hews
hobs97038982_hobs
hods87239862_hods
hoes75755732_hoes
hogs87139662_hogs
hols76946292_hols
hons77350782_hons
hops97942632_hops
hos68364192_ho_s
hots78349332_hots
how97252432_how_
howe106734102_howe
howes114730262_howes
howf136127202_howf
howfs144814502_howfs
howk145221962_howk
howks155016852_howks
howl107625692_howl
howls116219222_howls
hoys107733932_hoys
jows146632092_jows
knows124912412knows
lows75843012_lows
meows104612682meows
mhos95517772mho_s
mows96340832_mows
nows75738232_nows
phons105221142phons
phots105418502phots
plows105419902plows
pows95537662_pows
prows106327012prows
rhos76319062rho_s
rows75941752_rows
scows106617802scows
shaws116226262shaws
shews115924712shews
shoes85429662shoes
shogs95319712shogs
shoos84226362shoos
shops104222902shops
shots84730852shots
show106229192show_
shown115216482shown
showy145714012showy
slows85323462slows
snows84719892snows
sows75342492_sows
stows86622702stows
thaws116515462thaws
thews117416192thews
thous86017262thous
throws129715232throws
tows78545552_tows
trows88826182trows
vows106626942_vows
vrows116115262vrows
whews145114492whews
whops135013932whops
wows104633492_wows
yows106433122_yows

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 Limit538001201.50035866.7
3Display Results1201200.0304000.0
 (SQL Overall)1786911201.623110099.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.