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

257 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
sour4593589(None) 
dour56330431dour
four76226861four
hour75827311hour
lour45430681lour
our36042891_our
pour611527471pour
scour75315531scour
slur45525151slur
soar46838671soar
sou37853691sou_
souk86127171souk
soul46435711soul
soup66232911soup
sours55230501sours
sous46947211sous
spur65321191spur
stour54916741stour
tour45530381tour
your78623431your
amour75014852amour
blur66020532blur
boar66134292boar
boor66130682boor
bourg84113842bourg
bourn75518482bourn
bout66353292bout
bur55744692_bur
clour76617282clour
coir66327242coir
cor59960942co_r
coup86729792coup
court75532772court
cur56841982_cur
doer57734702doer
door56928512door
dor47253922do_r
dorr56627722dorr
doum76226672doum
doura66518662doura
doux125817982doux
flour84916452flour
for66952072fo_r
fou66743782fou_
foul77027582foul
fours85521492fours
fur66637322_fur
gaur56723352gaur
goer56827102goer
gor47848262go_r
gourd71011902gourd
gout56646002gout
hoar76729162hoar
hoer76533982hoer
houri85915252houri
hours85422392hours
jouk156015992jouk
knur85311972knur
kor76538892ko_r
loud55228042loud
loup66028432loup
lours55125292lours
loury85716752loury
lout45952142lout
mohur1036512mohur
moor66628552moor
mor56855002mo_r
moue65835572moue
mourn77215012mourn
noir46722432noir
nor38048822no_r
noun45724182noun
nous46136982nous
oar37057952_oar
odour64710492odour
or27354732_o_r
osar46820952osar
oud47439072_oud
ours47237562_ours
out38072152_out
poor65630222poor
pouf95732642pouf
pours74623182pours
pout65752552pout
pur56840552_pur
roar46328572roar
roue45941742roue
roup66627692roup
rout46153282rout
roux117419362roux
sapour83812372sapour
sau36356572sau_
saul45836522saul
saury84317222saury
savour94110702savour
scar66434202scar
scaur75814902scaur
scours84913592scours
scout75031452scout
scud76221282scud
scum85924522scum
scup84822382scup
scurf104719322scurf
scut65835542scut
sear47353842sear
seer45547042seer
ser36752402s_er
shoer84722162shoer
shout85433172shout
shul75823152shul
shun75122772shun
shut76137592shut
sieur5911892sieur
sir35746672s_ir
skua86113152skua
slub65428032slub
slue45332192slue
slug55124642slug
slum65430512slum
slurb74116322slurb
slurp74014982slurp
slurs54123372slurs
slut45040592slut
smug75815262smug
smut66629782smut
snout54530632snout
snub65320762snub
snug55218692snug
so28855442so__
soak87227662soak
soap65831132soap
soars54732512soars
sob57857942so_b
soba64927922soba
sober74822412sober
sobs64941752sobs
soca66330052soca
sock105233212sock
sod46053702so_d
soda56329382soda
sods54940212sods
sofa75625602sofa
sofar86115492sofar
soft76942822soft
soil46138832soil
soja115619512soja
soke85436262soke
sol37256622so_l
sola45541862sola
solar55927342solar
sold54837412sold
sole46053672sole
soli46637012soli
solo45538942solo
sols45448162sols
solum74717612solum
solus54726982solus
som59153812so_m
soma65635292soma
some66040382some
soms66239372soms
son37761952so_n
sonar56523422sonar
sone46649982sone
song55133672song
sons46049552sons
sook84933392sook
soon46240502soon
soot45761062soot
sop57557862so_p
soph97024202soph
sopor74016492sopor
sops65244562sops
sora45746912sora
sorb68333042sorb
sord56237202sord
sore47059532sore
sorer56236582sorer
sori46039842sori
sorn46641062sorn
sorry84618252sorry
sort46264812sort
sorus54527582sorus
sos37761602so_s
sot310384302so_t
soth75932522soth
sots45552452sots
souari6311382souari
soucar839322soucar
sough95320462sough
souks94820522souks
souls55127362souls
sound64420022sound
soups75322942soups
soupy106115402soupy
source8410672source
soured74921862soured
sourer63620212sourer
sourly93612212sourly
souse56530772souse
souter64225922souter
south85223572south
sow66554762so_w
sowar85821342sowar
sower85229312sower
sown75127452sown
sows75342492sows
sox106444192so_x
soy67851452so_y
soya75724432soya
soys75233932soys
soyuz1748852soyuz
spar65433302spar
spoor75016352spoor
spout75029632spout
spud75818492spud
spue66025522spue
spun66221462spun
spurn74815452spurn
spurs74621522spurs
spurt77227982spurt
star48037762star
stir45723252stir
stoup75517072stoup
stoure64814942stoure
stours65015632stours
stoury9529942stoury
stout57434052stout
stub66221842stub
stud56220092stud
stum65526022stum
stun45623452stun
sturt56028962sturt
sub55445552s_ub
sue35651462s_ue
suer45334032suer
suk75632972s_uk
sum56346012s_um
sun37149032s_un
sup57041942s_up
suq126228992s_uq
sura45740292s_ura
surd56433812s_urd
sure45447412s_ure
surf76039312s_urf
swoun84811492swoun
swum96416822swum
tor39261682to_r
torr45630902torr
tours55325892tours
tout46753822tout
waur76819902waur
you66641822you_
yourn87512772yourn
yours85217882yours
yous76230652yous
zouk174413542zouk

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.0802233637.5
2DLD Change Limit298722570.95331345.2
3Display Results2572570.0634079.4
 (SQL Overall)1786912571.096163039.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.