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

300 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
dolour7571013(None) 
colour85915081colour
dolor67617961dolo_r
dolours8438811dolours
clour76617282_clour
color76123742colo_r
colours95913412colours
decolour1185012decolour
detour778192detour
devour1076702devour
dollar74110982dollar
dolors75115312dolors
donor64418192dono_r
door56928512do_o_r
dour56330432d__our
dyvour1393342dyvour
flour84916452_flour
honour94710862honour
lour45430682__lour
odour64710472_odour
valour93010372valour
velour9328762velour
aloud65018063_aloud
amour75014853_amour
arbour84211323arbour
ardour74110893ardour
armour84411853armour
bicolour1243693bicolour
blur66020533_bl_ur
bolar75123473bol_ar
bolder94820933bolder
bolo65535953bolo__
bolos75531373bolo_s
bolter83920753bolter
bolus79125543bol_us
boor66130683bo_o_r
bulgur9387533bulgur
cloud86716423_cloud
clours85215083_clours
clout75330463_clout
colder95121833colder
coleus86818273coleus
collar83816173collar
colobi105011083colobi
colobus11389373colobus
colog86619933colo_g
cologs96517353cologs
colon78630193colo_n
colone85425003colone
coloni85619203coloni
colons86028683colons
colonus94413443colonus
colony115417273colony
colorer9312523colorer
colors86622373colors
coloured1148303coloured
colourer1037553colourer
colter84625093colter
colure8314153col_ure
comous10816503comous
concur10411093concur
contour939963contour
cooer74831013co_oer
cooler84824713cooler
copout10418773copout
couloir936143couloir
decolor1087033decolo_r
decolours1274413decolours
decor84717573deco_r
delouse839833delouse
delouser936363delouser
delver104913493delver
demur8311163d_emur
detours858033detours
devoir1076033devoir
devours1166643devours
devout10712993devout
dimout9414243dimout
discolour1244173discolour
diseur738843diseur
dobber114015413dobber
doblon938013doblo_n
doblons1037043doblons
docker134417653docker
doctor938993doctor
dodder94712913dodder
dodger95817043dodger
dodo66024913dodo__
dodoes85716103dodoes
dodos75819393dodo_s
doer57734703d__oer
doffer133911353doffer
dogear838193dogear
dogger95216783dogger
dojo126016143dojo__
dojos135111793dojo_s
dol47150653dol___
dolce85816683dol_ce
dolci84912603dol_ci
dole56550003dol__e
doled75430913dol_ed
doleful1146333doleful
doles67843753dol_es
doling84923133doling
doll56632493dol__l
dollars83311023dollars
dolled83518073dolled
dollop9259363dollop
dollops10287963dollops
dolls66126923dol_ls
dolly96125203dol_ly
dolma86214173dol_ma
dolman95312403dolman
dolmas95213043dolmas
dolmen93911373dolmen
dolorous947843dolorous
dols56943053dol__s
dolt56649423dol__t
dolts65626313dol_ts
donors75115793donors
donut6324513do_nut
doody105517913do_ody
doofus1036163doofus
doolee73018953doolee
doolie73916833doolie
dooly94821803do_oly
doom76430073do_o_m
dooms85321343do_oms
doomy116018263do_omy
doors65022133do_ors
doozer163910463doozer
doozy186813713do_ozy
doper86128393do_per
dopier93515923dopier
dor47253923d__o_r
dorbug1034953dorbug
dormer94415893dormer
dorper94314563dorper
dorr56627723d__orr
dorser74819173dorser
dorsum947623dorsum
doser66228563do_ser
dosser74417973dosser
doter65428623do_ter
dotier73917033dotier
dotter74419343dotter
douceur1043113douceur
doum76226673d__oum
doura66518663d__oura
dourer74215273dourer
douser75621633douser
doux125817983d__oux
dower95027703do_wer
downer104414923downer
downpour1443003downpour
dowser104716083dowser
dozer158419273do_zer
dozier163611633dozier
droller84110283droller
dropout10410003dropout
drouk1039433d_rouk
dugout8310363dugout
duller74017703duller
duolog835803duolo_g
duologs935363duologs
duologue1043003duologue
dyvours1453183dyvours
ecotour944353ecotour
favour12438333favour
floor84215233_floor
flours94414053_flours
floury12449573_floury
flout86226203_flout
fluor84512773_fluor
folder104317543folder
foldout1149523foldout
foldup1233813foldup
foliar93210973foliar
folious103710733folious
folium11310453folium
four76226863__four
giaour735363giaour
glout65925813_glout
golder84417603golder
goldurn943323goldurn
golfer104411183golfer
golosh1036463golosh
holder104619653holder
holdout11510893holdout
holdup1245183holdup
holier94921623holier
holler93520613holler
honor85718623hono_r
honours10339353honours
hour75827313__hour
humour11116753humour
inpour837063inpour
iodous7311493iodous
jolter133513093jolter
joyous16276763joyous
kolo87026223kolo__
kolos94921213kolo_s
kultur1034433kultur
labour84210933labour
loller63315283loller
loud55228043__loud
loup66028433__loup
lours55125293__lours
loury85716753__loury
lout45952143__lout
mohur1036513mo_hur
molar75223093mol_ar
molder93819273molder
moloch1356483moloch
molter84119423molter
moor66628553mo_o_r
motor75317293moto_r
nodous7711323nodous
nolo46229313nolo__
nolos54423353nolo_s
occur9137323_occur
odious749933odious
odor55718093_odo_r
odorous837663odorous
odours7418233_odours
older65121173_older
oleum73613323_oleum
ology94113113_ology
oology103210253oology
oolong738073oolong
our36042893___our
parlour937263parlour
pilous84717753pilous
polar75623453pol_ar
polder94019253polder
poler74431793pol_er
poller83921853poller
polo66236633polo__
polos76129913polo_s
pooler83819843pooler
poor65630223po_o_r
porous84419483porous
poseur8419403poseur
pour611527473__pour
poyou102611523poyou_
poyous112911623poyous
repour8310993repour
rigour7258023rigour
rolfer94412273rolfer
roller63919793roller
rollout7811943rollout
rotor55519733roto_r
rumour8127373rumour
sapour83812373sapour
savour94110703savour
scour75315533_scour
slur45525153_sl_ur
sojourn1442893sojourn
solar55927343sol_ar
solder73921343solder
soleus64615613soleus
solo45538943solo__
soloed74515743soloed
solon55026133solo_n
solons65120013solons
solos54830793solo_s
solum74717603sol_um
solus54726983sol_us
solver94016703solver
sopor74016493sopo_r
sour45935893__sour
stour54916743_stour
sulfur937913sulfur
tabour84011313tabour
tenour62610733tenour
tolar55524113tol_ar
toller63819443toller
tolu45529153tol_u_
toluol636903toluol
tolus55024483tol_us
tooler63818613tooler
torous64319023torous
tour45530373__tour
tumour8137393tumour
valor83614893valo_r
valours10248733valours
vapour11378873vapour
velours10278083velours
vigour10256803vigour
vodou939343vodou_
vodoun1036233vodoun
vodous1038593vodous
volar86917413vol_ar
volost9412643volost
voyeur1232863voyeur
wolfer12429983wolfer
wolver12419713wolver
wooer84316693wo_oer
wooler93615873wooler
your78623433__your

Search took 7 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.1431249587.4
2DLD Change Limit1127163006.21618133.2
3Display Results3003000.0963125.0
 (SQL Overall)1786913006.45527682.6
 
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.