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

84 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
cheddar1425473(None) 
cheddars15234381cheddars
cheddary18293331cheddary
chuddar14263961chuddar
cedar84014322c_e_dar
chadar1239352ch_adar
cheder125113492che_der
chuddah17263252chuddah
chuddars15253462chuddars
chudder14245942chudder
khaddar1642112khaddar
shedder12339322shedder
bedder104215793_bedder
caesar8410943cae_sar
calendar1145013calendar
cedarn9408443c_e_darn
cedars93312833c_e_dars
cedary12419603c_e_dary
ceder85322243c_e_der
cellar84514983c_ellar
chadars1338293ch_adars
chador1238673ch_ador
char95132153ch___ar
cheap126915943che__ap
cheaper144010583cheaper
cheat105732453che__at
cheater124816963cheater
checker18329533checker
cheddite1543953cheddite
cheders134512393cheders
chedite1338863chedite
cheeper143610743cheeper
cheer105420383che__er
cheerer123511763cheerer
cheetah1545453cheetah
chefdom18134073chefdom
chela103916803che_la_
chelae113614613che_lae
chelas113817203che_las
chequer2135153chequer
chetah14399583che_tah
chewer145512623che_wer
chewier1537593chewier
chidden14255223chidden
chider125116053ch_ider
chimar133911473ch_imar
chordal13449883chordal
chowder16387813chowder
chuddahs18222583chuddahs
chudders15235563chudders
chukar1534633ch_ukar
chukkar1542053chukkar
clear76219053cle__ar
codder104416343c_odder
credal9311673cre_dal
creedal1037093creedal
deodar837713_deodar
header104422543_header
hear76143883_he__ar
heddle114211163_heddle
heder95623643_he_der
hedger114912653_hedger
heeder104216043_heeder
herder104516463_herder
heyday1635143_heyday
keddah1534273_keddah
khaddars1741993khaddars
kheda1346543khe_da_
khedah1743643khe_dah
khedas1446313khe_das
medlar93010463_medlar
pedlar93311273_pedlar
redder83918143_redder
redear73515173_redear
schedular1562473schedular
shear85424833she__ar
shedded13419063shedded
shedders13267433shedders
shredder1334403shredder
shudder12297323shudder
sledder9399203sledder
tedder83312163_tedder
thenar92610003the_nar
wedder113612303_wedder

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 Limit134027846.96619240.2
3Display Results84840.0332545.5
 (SQL Overall)178691847.40524131.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.