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

177 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
dreidel93447(None) 
dreidels1033211dreidels
dreidl835231dreid_l
deride84420032deride_
derided102914252derided
derider93214972derider
derides93420852derides
dreaded103612022dreaded
dreidls934052dreidls
drivel105110382dr_ivel
oreide7311672oreide_
oreides8312022oreides
seidel7311082_seidel
ureide7310362ureide_
ureides8311102ureides
arider74717743ar_ider
ariel55228973ar_i_el
bedel84219393_be_del
braided114013213braided
braider105112993braider
breaded115014063breaded
brede85520503bre_de_
bredes94818473bre_des
breeder103210043breeder
bridal9511453br_idal
bride86425533br_ide_
brides94423513br_ides
bridle94115463br_idle
broider103912973broider
credal9311673cre_dal
creedal1037093creedal
creel75121483cre__el
crenel84213063cre_nel
crewel114310473cre_wel
daedal849083dae_dal
deaden83714323d_eaden
deader84220473d_eader
decibel1235993decibel
decide104116873decide_
decided124312423decided
decider114213183decider
decides114217653decides
deckel134911043d_eckel
dedal75719023d_e_dal
deeded94615543d_eeded
deedier93011593deedier
defuel10348933d_efuel
deice84320033d_eice_
deiced104214483d_eiced
deicer94114413d_eicer
deices94119373d_eices
deil56231623d_ei__l
deriders102411853deriders
derive103817043derive_
derived123912763derived
deriver114213913deriver
derives114017813derives
devel94217123d_e_vel
diel59034603d__i_el
diesel74410403die_sel
divide113410893divide_
divided13378593divided
divider12278953divider
divides123211453divides
djebel1643453dje_bel
drail65020973drai__l
drained93713253drained
drainer83012843drainer
dread74419023dread__
dreadful1343223dreadful
dreads84115023dread_s
dreamed114310633dreamed
dreamer104110843dreamer
dredge9308553dre_dge
dredged11346883dredged
dredger10347443dredger
dredges10379343dredges
dree56638323dre__e_
dreed75222843dre__ed
drees65628523dre__es
dreich12377723drei_ch
dreigh11246443drei_gh
dressed93511873dressed
dresser83611953dresser
dresses83716173dresses
dried75321383dr_i_ed
drier64423963dr_i_er
dries64733673dr_i_es
drill64718263dr_i_ll
drive95318003dr_ive_
drivels11397923dr_ivels
driven105210143dr_iven
driver104714493dr_iver
drives105117113dr_ives
droid74218543droid__
droids84712583droid_s
druid74111323druid__
druidess1043083druidess
druidic1143523druidic
druids8368093druid_s
dryades12395633dryades
duende836923duende_
duendes938193duendes
eide55832233__eide_
eider64624743__eider
fresnel1035893fresnel
greige847203greige_
greiges937733greiges
greisen856503greisen
gride75223583gr_ide_
grided95117043gr_ided
grides84422363gr_ides
infidel1146043infidel
irides74519123ir_ides
nereides938503nereides
oriel54920423or_i_el
oroide7311703oroide_
oroides8311973oroides
predial103815413predial
prequel1836343prequel
preside10715613preside_
presided12410553presided
presider11410423presider
presides11414913presides
pretzel1835143pretzel
pride84724733pr_ide_
prided103618033pr_ided
prides94324183pr_ides
raided85017703_raided
raider74318743_raider
reader73628293_reader
rebel73421293_re_bel
redded94019543_redded
redden83613613_redden
redder83918133_redder
reddle83815913_reddle
rede55037663_re_de_
reded74829113_re_ded
redes65139123_re_des
redial74923113_redial
reeded84022563_reeded
reel45240533_re__el
refeel93913243_refeel
refel84920813_re_fel
refuel93912623_refuel
reheel93610823_reheel
reindex1536093_reindex
reined74425523_reined
reive85522943_reive_
reived104518133_reived
reiver95318293_reiver
reives95723043_reives
remodel1038093_remodel
rended84524103_rended
render74024143_render
repel74921403_re_pel
reside74224933_reside_
resided95217703_resided
resider84615803_resider
resides84523283_resides
revel84423163_re_vel
rewiden1137533_rewiden
ride55945123_r_ide_
rider65231303_r_ider
rides66140813_r_ides
ridgel8399963_r_idgel
riel46432383_r_i_el
rondel73212643_rondel
seidels838393_seidels
treaded95014283treaded
treader84113833treader
treadle8310103treadle
treddle936433treddle
trended94011763trended
tressel73010893tressel
uredial82910483uredial
wedel94513953_we_del

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.1561145455.1
2DLD Change Limit1340271776.96619240.2
3Display Results1771770.0632809.5
 (SQL Overall)1786911777.18524870.0
 
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.