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

223 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
siddur83457(None) 
siddurs934171siddurs
bidder104114862bidder
kidder123811102kidder
ridder84015142ridder
sadder82916972sadder
siddurim12111452siddurim
sidler74716962sidler
sieur5911892si_eur
sirdar7269102sirdar
skidder1365732skidder
widder112913972widder
adder75419593_adder
aider65431133ai_der
aidful1057073aidful
ardour74110903ardour
badder103817513badder
bedder104215793bedder
bidden104010793bidden
bidders114012313bidders
biddy124612693bidd_y
bider85728373bi_der
binder94422873binder
birder94915493birder
budder104314813budder
cider84723313ci_der
cinder94119123cinder
codder104416343codder
diddle94915213diddle
diddler103511513diddler
diddly12389573diddly
dirdum1036033dirdum
diseur738843diseur
dodder94712913dodder
dour56330433__dour
eider64624743ei_der
fiddle113613383fiddle
fiddler12309953fiddler
fiddly14328483fiddly
finder104020233finder
fodder114712113fodder
gadder93714713gadder
giaour735363giaour
giddap1143413giddap
giddier10308723giddier
giddy115810203gidd_y
giddyup154863giddyup
gilder84415533gilder
girder84312063girder
gridder10367763gridder
hidden11429743hidden
hider95024083hi_der
hinder104120063hinder
idler65015663_idler
incur72212253_incur
indue63516673_indue
judder15439423judder
kidded13299393kidded
kidders13399173kidders
kiddie12359393kiddie
kiddo11398953kidd_o
kiddos12416863kiddos
kiddush16242483kiddush
kiddy144910283kidd_y
kinder113716843kinder
ladder84617623ladder
lidar6312723li_dar
lidded93410243lidded
lieder74912323lieder
madder103515593madder
midair937993midair
midday13327503midday
midden104112853midden
middle103414983middle
middler112712273middler
middy124812593midd_y
midgut103510053midgut
milder93818453milder
minder94822503minder
mudder104413493mudder
nidus65913573ni_dus
nodder84811943nodder
odder74515393_odder
odour64710493_odour
oidium959813oidium
padder103415493padder
piddle103514913piddle
piddler112911523piddler
piddly13319143piddly
pinder94523453pinder
qindar16317173qindar
redder83918143redder
ridded93615123ridded
ridden83511723ridden
ridders93612493ridders
riddle83915713riddle
riddler93411263riddler
rider65231303ri_der
rigour7258023rigour
rudder83812803rudder
sadden83212403sadden
saddhu1133413saddhu
saddhus1243673saddhus
saddle83915493saddle
saddler93811963saddler
sadhu9459963sadhu_
sadhus10298463sadhus
sambur10469503sambur
sandbur10105353sandbur
sander74828533sander
santur6311273santur
sapour83812373sapour
sardar73013173sardar
savour94110703savour
scaur75814903s_caur
scour75315533s_cour
seder64826763s_eder
sedum84115573s_edum
seeder74320773seeder
sender73824413sender
sendup9106343sendup
shader104218763shader
shaduf1337063shaduf
shedder12339323shedder
shudder12297323shudder
sicker124023903sicker
side55444493si_d_e
sidearm1035973sidearm
sidebar1045563sidebar
sidecar1045233sidecar
sided74825953si_ded
sides65838363si_des
sidh86222993si_d_h
sidhe95315103si_dhe
siding83822133siding
sidle65124033si_dle
sidled84215173sidled
sidlers83414233sidlers
sidles74721153sidles
sieurs659043si_eurs
sifter94516233sifter
sigher103813703sigher
siglum936563siglum
signer74015633signer
signor73510353signor
siker95326033si_ker
sild55030583sild__
silds65520523sild_s
siller64026063siller
silver93815813silver
simar74920813si_mar
simmer104115353simmer
simper103616293simper
sinful938803sinful
singer74227313singer
sinker103620903sinker
sinner64320603sinner
sinter63625923sinter
sinus55523853si_nus
sipper103920993sipper
sir35746673si___r
sirdars8228213sirdars
sirup74014913si_rup
sister64421583sister
sitar54820543si_tar
sitter63323383sitter
situp74414063si_tup
situs55019233si_tus
siver85728613si_ver
sizar145214993si_zar
sizer145521813si_zer
sizier1514813393sizier
skidded1465083skidded
skidders1454823skidders
skiddier1464193skiddier
skiddoo1342553skiddoo
skiddy1533633skidd_y
sledder9399203sledder
slidden935153slidden
slider73918363slider
slur45525153s__lur
smeddum1342853smeddum
snider74413913snider
sodded94113303sodded
sodden84011513sodden
soddy104210703sodd_y
sodium92111453sodium
solder73921343solder
sonder73623523sonder
sordor7310223sordor
sour45935893s__our
spader94317133spader
spider94516803spider
spudder11256553spudder
spur65321193s__pur
stour54916743s_tour
subdue9128493subdue
subduer10107033subduer
sudd64719773sudd__
sudden83310833sudden
sudds75513593sudd_s
sudor6312623s_udor
sudser73511283sudser
sulfur937913sulfur
sunder74019823sunder
swidden1234233swidden
tedder83312163tedder
tiddler93110003tiddler
tiddly11308783tiddly
tidier73515113tidier
tinder73821803tinder
udder76314283_udder
vigour10256803vigour
wadder114215483wadder
wedder113612303wedder
widders123512273widders
widdie113410733widdie
widdle113814843widdle
widdy136112183widd_y
wider94826353wi_der
wilder103616473wilder
winder104025263winder
windup1235383windup

Search took 6 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.393454684.5
2DLD Change Limit1127162234.89023050.3
3Display Results2232230.0762934.2
 (SQL Overall)1786912235.35933344.1
 
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.