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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

128 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
cadre8541902(None) 
cade76443911cad_e
cadge94018791cadge
cadres94017931cadres
care66968371ca_re
madre85720171madre
padre86018161padre
acre67330772_acre
adore65723672_adore
adze1412820572_adze
are37874572_a_re
bade75140882bad_e
badge94819692badge
barde85330772barde
bare65460522ba_re
barre75929542barre
caber95126832caber
cable95329912cable
cache125122482cache
cad67456362cad__
caddie104316452caddie
caddy125414022caddy
cades85440732cades
cadet85339342cadet
cadged114812342cadged
cadger105013912cadger
cadges104716712cadges
cadgy125210782cadgy
cadi75732182cad_i
cadis84428502cadis
cads76144522cad_s
cafe95230322ca_fe
cage75339062ca_ge
cager85229222cager
caird85717232caird
cairn75717512cairn
cake105439962ca_ke
calve105919922calve
came87648752ca_me
candle94321482candle
cane66653122ca_ne
caner75334772caner
canoe75627252canoe
cape87242782ca_pe
caper94831622caper
car59165562ca_r_
carb85143162ca_rb
card710245872ca_rd
carded105424902carded
carder94524182carder
cards85137932cards
cared86050092ca_red
carer74942332ca_rer
cares77369182ca_res
caret75360562ca_ret
carex144822302ca_rex
cark105539272ca_rk
carl65144782ca_rl
carle74535702carle
carn66245432ca_rn
carp85139812ca_rp
carr65434702ca_rr
carrel84718632carrel
carrs75730852carrs
carry105823782carry
cars67364762ca_rs
carse74934332carse
cart66570342ca_rt
carte75940422carte
carve106227752carve
case65848082ca_se
caste75932362caste
cate66254602ca_te
cater74840722cater
caudle93912912caudle
cause75225352cause
cave95941262ca_ve
caver105629062caver
cavie104621592cavie
cede74928772ced_e
ceder85322242ceder
cere66741472c_ere
chadri1238142chadri
chare105231982chare
chore105126762chore
cider84723312cider
cire65836372c_ire
clade85821012clad_e
code77347732cod_e
coder86134222coder
core67263112c_ore
cradle93313162cradle
crore74922872crore
cure66149122c_ure
cyder114611132cyder
dare55848862da_re
eagre64315322eagre
fade85736342fad_e
fader94421512fader
fadge104817002fadge
fare76354462fa_re
gadje1457742gadje
hade85440192had_e
hare76255732ha_re
jade125325442jad_e
lade56345982lad_e
lader65633722lader
ladle66320442ladle
made75440242mad_e
madres93718182madres
mare64759332ma_re
nacre75715362nacre
padle84522342padle
padres95016982padres
padri85815172padri
pare66760842pa_re
rare45348432ra_re
sabre74821502sabre
sade55544472sad_e
sadhe94815132sadhe
scare75334462sca_re
tare45957622ta_re
tarre55825632tarre
wade85237062wad_e
wader95325362wader
ware76254722wa_re
yare75636942ya_re
zaire14311992zaire

Search took 3 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 Filter178691538000.296603685.8
2DLD Change Limit538001281.70331591.3
3Display Results1281280.0304266.7
 (SQL Overall)1786911282.02988068.5
 
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.