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

67 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
rondelet941035(None) 
rondelets1045261rondelets
rondel73212642rondel__
rondelle946812rondelle
rondelles1046622rondelles
rondels82510052rondel_s
roundlet9209222round_let
rundlet83114152rund_let
boneset9316433bon_eset
condole102914953condole_
condoled123110723condoled
condolent1249833condolent
condoler113412123condoler
condoles113015803condoles
condyle13247053condyle_
condyles14277463condyles
corselet10414573corselet
fondest11312403fonde_st
fondle104412943fond_le_
fondled12399423fond_led
fondler11348883fond_ler
fondles113512613fond_les
frontlet1147653fron_tlet
hondle103914523hond_le_
hondled123510653hond_led
hondles113614523hond_les
lancelet1049473lancelet
mantelet10613823mantelet
modeled1139463mo_deled
modeler1039293mo_deler
nondesert1048193nondesert
nonelect10410283non_elect
omelet8317073_o_melet
pondered126411293pondered
ponderer112410193ponderer
princelet1346533princelet
relet54749823r___elet
rendered102512263rendered
renderer9239743renderer
ringlet82818173rin_glet
rodent7519243ro_de_nt
rodeoed937883ro_deoed
rondeau846813ronde_au
rondeaux1642653rondeaux
rondure837313rondure_
rondures937713rondures
ronnel63310883ronnel__
ronnels7318613ronnel_s
rootlet73015733ro_otlet
roundel8308853roundel__
roundelay1342723roundelay
roundels9217753roundel_s
roundest9310473rounde_st
roundlets10175293round_lets
roweled11269863ro_weled
rundle73214233rund_le_
rundles83214713rund_les
rundlets9307363rund_lets
runlet63821413run__let
tonlet62924703ton__let
underlet91516213_underlet
urodele845963uro_dele_
urodeles945563uro_deles
wondered13239943wondered
wonderer12249183wonderer
yodeled1236863yo_deled
yodeler1136343yo_deler

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 Filter1786911461620.406440125.6
2DLD Change Limit146162676.54622328.4
3Display Results67670.0302233.3
 (SQL Overall)178691676.98225593.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.