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

142 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
cadet8533933(None) 
cade76443911cade_
cadent94120351cadent
cades85440731cades
cadets96316501cadets
caret75360561caret
abet610547942_abet
adept81219642_adept
adit56443652_adit
bade75140882bade_
bidet84935622bidet
caber95126832caber
cablet104429462cablet
cachet134526412cachet
cad67456362cad__
caddy125414022caddy
cadge94018782cadge
cadged114812332cadged
cadger105013892cadger
cadges104716702cadges
cadgy125210782cadgy
cadi75732172cad_i
cadis84428492cadis
cadre85419012cadre
cadres94017922cadres
cads76144522cad_s
cafe95230322cafe_
cafes106426922cafes
cage75339062cage_
caged95426362caged
cager85229222cager
cages85936012cages
cagey115917822cagey
cake105439962cake_
caked126128622caked
cakes116037672cakes
cakey145517272cakey
callet84536762callet
came87648752came_
camel96822802camel
cameo95924992cameo
cames97047312cames
camlet104426582camlet
candent10417362candent
cane66653112cane_
caned85838092caned
caner75334772caner
canes75350372canes
canst74932212canst
cant66362022ca_nt
cape87242782cape_
caped104931802caped
caper94831622caper
capes95441922capes
caplet104226812caplet
caput9823972caput
carat75048792carat
carded105424902carded
carder94524182carder
care66968372care_
cared86050092cared
carer74942332carer
cares77369182cares
carets85330772carets
carex144822292carex
carnet84732872carnet
carpet104530092carpet
cart66570342ca_rt
carte75940422carte
case65848082case_
cased86032412cased
cases75048382cases
casket124820992casket
cast67159902ca_st
caste75932362caste
cat58282342ca__t
cate66254592cate_
cater74840702cater
cates75951872cates
caudex1636392caudex
cave95941262cave_
caveat11417722caveat
caved116227562caved
caver105629062caver
caves105639702caves
cawed116627062cawed
cede74928762cede_
ceded96118552ceded
ceder85322232ceder
cedes84927322cedes
chalet113825992chalet
cider84723312cider
civet105828732civet
clade85821012clade_
clades94920462clades
claret84026572claret
code77347732code_
codec107120342codec
coded95433182coded
coden86128542coden
coder86134212coder
codes86247292codes
codex155817572codex
comet95946072comet
coset75748842coset
covet105638942covet
cruet74831842cruet
culet76040342culet
curet75447642curet
cyder114611132cyder
facet106038522facet
fade85736342fade_
faded105025242faded
fader94421512fader
fades94932862fades
gadget93616172gadget
godet7530042godet
hade85440192hade_
haded105227622haded
hades96035112hades
hadst93220222hadst
haet75659502ha_et
jade125325442jade_
jaded144417032jaded
jades135222112jades
lade56345982lade_
laded74232612laded
laden65022192laden
lader65633722lader
lades65141272lades
made75440232made_
palet74650802palet
ramet75743142ramet
sade55544472sade_
sades65239892sades
tacet75840022tacet
valet84337872valet
wade85237062wade_
waded106024752waded
wader95325362wader
wades95634142wades
wadset10314302wadset

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.0931921408.6
2DLD Change Limit538001421.93627789.3
3Display Results1421420.0334303.0
 (SQL Overall)1786911422.06286659.1
 
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.