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 “urodeles” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

79 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
urodeles94556(None) 
urodele845961urodele_
boodles103416043bood_les
bordels103911973bordel_s
bridles104114473brid_les
coddles114213593_coddles
codeless112010113_codeless
cordelles1248223cordelles
cradles103114123crad_les
curdles103814573cur_d_les
deles65139253___deles
doodles93614163dood_les
erodes74819883erod__es
frogeyes1543743frogeyes
gradeless11236703gradeless
griddles1145753griddles
groveled13345453groveled
groveler12305843groveler
grovelers13305163grovelers
groveless13235363groveless
grovels11427813grovel_s
hurdles113613373hur_d_les
modeled1139453_modeled
modeler1039293_modeler
modelers1138463_modelers
models94216353_model_s
modules102511003_modules
noddles92911293_noddles
nodules8269703_nodules
noodles83513193nood_les
odyles10348563__odyles
oodles73517183_ood_les
poodles103013513pood_les
produces1347903produces
profiles133211233profiles
proles84627203pro__les
propels113412843propel_s
propenes122816513propenes
proteges1149923proteges
protyles13249833protyles
raddles93615703_raddles
reddles93315773_reddles
redeyes112910973_redeyes
riddles93215023_riddles
robles85321693_ro_bles
rodents8611543_rodents
rodeoed937883_rodeoed
rodeos75314503_rode_os
rodes614039083_rod__es
rodless8310073_rodless
roles56747983_ro__les
rondelet9410353_rondelet
rondelets1045263_rondelets
rondelles1046623_rondelles
rondels82510053_rondel_s
rootles73215633_rootles
roselles8310713_roselles
roubles93413503_roubles
roweled11269863_roweled
rowels94515453_rowel_s
ruddles92813873_ruddles
rundles83214713rund_les
toddles93211533_toddles
treddles1036263treddles
troubles1057183troubles
troweled12106113troweled
troweler11106063troweler
trowelers12105253trowelers
trowels10358363trowel_s
ukeleles1252663ukeleles
ukuleles1242183ukuleles
unriddles1143503unriddles
uridines989513uridines
urostyles12173973urostyles
yodeled1236853_yodeled
yodeler1136343_yodeler
yodelers1235673_yodelers
yodels104610073_yodel_s
yodles103714333_yod_les

Search took 9 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 Filter1786911461620.1561145455.1
2DLD Change Limit146162798.04618165.8
3Display Results79790.0302633.3
 (SQL Overall)178691798.23221706.9
 
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.