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

137 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
padauk133564(None) 
padauks1443941padauks
padouk1336681padouk
padouks1434862padouks
aback134816173_aback
adage7414053_adage
adapt81218553_adapt
adzuki2042513_adzuki
alack114820063_alack
apeak115513453apea_k
arak86929573_ara_k
auk76234143___auk
badass949293badass
bedaub1146033bedaub
carack142113173carack
dada66422443dada__
dadas75819863dada_s
dadgum1134583dadgum
dak86340693__da_k
damask1335843damask
dank95828233__dank
dark95133213__dark
daub77423443__daub
daut56443563__daut
dawk126117283__dawk
gagaku1243813gagaku
hadal95518123hada_l
hamaul114210863hamaul
jauk155816093__jauk
kaiak8310353kaia_k
kayak1138363kaya_k
ladanum1045183ladanum
landau7310613landau_
landaus8310343landaus
madam10316223mada_m
madame1139853madame
madams11310943madams
mamluk1434743mamluk
maraud938943maraud
nada58022903nada__
nadas66320813nada_s
pablum1237503pablum
paca85132243paca__
pacas96029403paca_s
pack125535443p__ack
pad68057323pad___
padded114113503padded
padder103415493padder
paddle104615143paddle
paddock17104733paddock
paddy125913593pad_dy
padi76331783pad__i
padis86227143pad_is
padle84522343pad_le
padles95221113padles
padlock1665813padlock
padnag1036073padnag
padnags1135083padnags
padre86018163pad_re
padres95016983padres
padri85815163pad_ri
pads76742953pad__s
paean77222723paea_n
paeans85118263paeans
pagan86121163paga_n
pagans95717923pagans
paik105726803p__aik
pajama17317653pajama
palace104516913palace
palais8420423palais
palapa10310673palapa
palate84226783palate
palpus104210283palpus
panada94113053panada
panama104213343panama
panda85022613panda__
pandani1039903pandani
pandanus1136433pandanus
pandas95521963panda_s
pandour10408213pandour
panful1179743panful
papa85827143papa__
papacy1547493papacy
papadum1475233papadum
papain10313793papain
papal95820673papa_l
papas94927493papa_s
papaw125112493papa_w
papaws13419113papaws
papaya1337503papaya
pappus9408373pappus
para65242173para__
parade94720643parade
parae76335703para_e
paramo102614643paramo
parang93715513parang
paraph13311263paraph
paras76143043para_s
pardah123412823parda_h
pardahs13289673pardahs
pareu74928743pareu_
pareus85420743pareus
park105237493p__ark
parous84024163parous
passus83610293passus
pataca10311193pataca
pavan106518473pava_n
pavane114113443pavane
pavans115715593pavans
payback2056453payback
payday1536613payda_y
paydays1634433paydays
payout11714653payout
pazazz1554023pazazz
peak106535203p_ea_k
pedal86022503peda_l
pedalo93811143pedalo
pedals94316033pedals
pedant9319493pedant
pedate93117763pedate
pilau73618523pilau_
pilaus84114133pilaus
plack135017843p_lack
plank115221143p_lank
podium112911913podium
prank115019453p_rank
prau66529473p_rau_
praus74621753p_raus
radar61316723rada_r
radars71314663radars
radium93513293radium
radius73914863radius
sadhu9459963sadhu_
sadhus10298463sadhus
taluk94812873ta_luk
wauk115220593__wauk
zaddik2134243zaddik

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.1401276364.3
2DLD Change Limit1127161375.78019501.0
3Display Results1371370.0502740.0
 (SQL Overall)1786911375.97029931.5
 
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.