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

156 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
rondure83731(None) 
rondures937711rondures
bordure1035782bordure
coendure1145462coendure
conduce12139232conduce
conjure16109072conjure
endure74014142_endure
fondue104510492fondu_e
ordure756812_ordure
tonsure758782tonsure
bandore10611633bandore
bondage1138253bondage
bonder95324783bonder_
bonders104120663bonders
bonduc1136603bondu_c
bonducs1235553bonducs
bonfire1287063bonfire
bordures1136173bordures
brochure1544353brochure
censure92310603censure
coendured1344093coendured
coendures1245213coendures
coenure968153coenure
coinsure1046933coinsure
colure8314163co_lure
concur10411103concur_
concurs11311473concurs
condole102914953condole
condone102616293condone
condor94616973condor_
condores113315643condores
condors104018573condors
conduced14136963conduced
conducer13127373conducer
conduces13129783conduces
conduct121411593conduct
conduit10713083conduit
condyle13247053condyle
confuse1238853confuse
confute1239263confute
conjured18117903conjured
conjurer17117683conjurer
conjures17119913conjures
conquer1838623conquer
consume11510133consume
contuse9311413contuse
couture9310623couture
denture8311893denture
dure56341813___dure
endue64215353_endu_e
endured93611213_endured
endurer83210363_endurer
endures83314603_endures
enduro7338623_enduro
ensure63416003_ensure
enure53520223_en_ure
fonder104120063fonder_
fondle104412943fond_le
fondler11348883fondler
fondu96013973fondu__
fondued12466363fondued
fondues11399313fondues
fondus105210943fondu_s
frondeur1242793frondeur_
frondeurs1342573frondeurs
frondose1244523frondose
goldurn943333goldurn
hondle103914523hond_le
honour94710863honour_
honoured1236313honoured
honourer1146243honourer
honours10339373honours
induce93811533_induce
indue63516673_indu_e
injure133410863_injure
insure63416603_insure
inure54119053_in_ure
ironware1144653ironware
jointure15134833jointure
kronur10415313kron_ur_
manure8313653man_ure
module93011033mo_dule
moidore1056153moidore
monde85723143mond__e
nodule7309803no_dule
noncore9411953noncore
nondrug944103nondrug
nonjury1744033nonjury
nonuse63212253non_use
ordures856473_ordures
pandore10411853pandore
pandura1037143pandura
perdure10379623perdure
ponder94521693ponder_
pondered126411293pondered
ponderer112410193ponderer
ponders103618843ponders
posture9313253posture
procedure1443383procedure
procure1138573pro_cure
produce1267513pro_duce
randier83618473randier
rapture937383rapture
rasure6311423r_asure
reduce9713253r_educe
reinduce1165423reinduce
reinjure1544983reinjure
reinsure837913reinsure
renature839323renature
render74024143render_
rendered102512263rendered
renderer9239743renderer
renders83821673renders
roadie72813813road_ie
rode55844303ro_d__e
rogue66417533ro_gu_e
rondeau846813rondeau
rondel73212643rond_el
rondelet9410353rondelet
rondelle946813rondelle
rondels82510053rondels
rondo65218373rond__o
rondos74616733rond_os
roque144812133ro_qu_e
roue45941743ro__u_e
rouge65423443ro__uge
rounder83514603rounder_
rounders92613693rounders
roundup1044063roundu_p
roundups1143593roundups
rouse56634703ro__use
route55132073ro__ute
rowdier11348593rowdier
rundle73214233rund_le
rupture966163rupture
soilure736233soilure
sonde64622833sond__e
sonder73623523sonder_
sonders83820713sonders
tenure6311613ten_ure
tongue7410093tongu_e
tonsured976383tonsured
tonsures869133tonsures
torture738593torture
undue66715553_undu_e
unpure82911533_unpure
unsure62815413_unsure
vendue10419013vendu_e
venture10311173venture
verdure11287773verdure
wonder103617813wonder_
wondered13239943wondered
wonderer12249183wonderer
wonders113315993wonders
yonder103214133yonder_
zonule1577483zon_ule

Search took 8 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 Filter1786911340270.406440125.6
2DLD Change Limit1340271566.53020524.8
3Display Results1561560.0632476.2
 (SQL Overall)1786911566.99925530.9
 
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.