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

228 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
langrel810703(None) 
gangrel996141gangrel
langrels9106171langrels
angel65019562_ang_el
gangrels1094972gangrels
langley1147452langley
langue71012172langue_
langues81211912langues
languet8713692languet
laurel649032la_urel
mandrel1038682mandrel
mangel94017532mang_el
mongrel1036332mongrel
agree65226033_a_gree
aigret73720023_aigret
angels74416173_ang_els
anger66225873_ang_er
angered93013473_angered
angerly1137773_angerly
angers75222543_angers
angle64528873_angle_
angled84219083_angled
angler74017863_angler
angles74426703_angles
angrier839023_angrier
angrily1137723_angrily
angry9310863_angr_y
antral65719413_antral
antre55224523_antre_
antres65021003_antres
anural65714743_anural
bagel85116793ba_g_el
banged104923723bang_ed
banger94423633bang_er
bangers104020353bangers
bangle94018953bangle_
bangles103617413bangles
barrel84517873ba_rrel
cancel105316683can_cel
cangue91012443cangue_
cangues10611823cangues
cannel84216403can_nel
carrel84718633ca_rrel
clanged114212653clang_ed
clanger104113493clang_er
clangers114312343clangers
clangored1343653clangored
danged94819483dang_ed
danger83722823dang_er
dangered11248513dangered
dangers94818213dangers
dangle84119303dangle_
dangled104013153dangled
dangler96912813dangler
dangles93618423dangles
doggrel1033883doggrel
eagre64315323ea_gre_
eagres74014573ea_gres
evangel1134303evang_el
fanged114318223fang_ed
flange103411973flang_e_
flanged123810843flang_ed
flanger113412623flang_er
flangers123311373flangers
flanges113413273flang_es
flannel1035423flan_nel
gambrel1235453gambrel
ganged94619193gang_ed
ganger83721463gang_er
gangers94418603gangers
gangrene1044363gangrene
gangue81310573gangue_
gangues9149753gangues
handsel11308723handsel
hangared1337573hangared
hanged114222393hang_ed
hanger104023253hang_er
hangers113120813hangers
hangmen1337383hangmen
hangul1049213hang_ul
hansel95214373han_sel
haverel13397153haverel
jangle144416293jangle_
jangled164111563jangled
jangler153811833jangler
jangles154015683jangles
laager74312783laag_er
laagered1055853laagered
laagers83411253laagers
label75019383la__bel
labored102810243labored
laborer9249503laborer
labret8320223la_bret
lager65132863la_g_er
lagered92311153lagered
lagers74826143la_gers
lagged95520133la_gged
lagger85919833la_gger
laggers94216243laggers
laired75216813la_ired
lamprey1434863lamprey
lanate6421263lanate_
lanated8313203lanated
lance75126723lan_ce_
lanced93717723lan_ced
lancer84319973lan_cer
lancers93616643lancers
lances84824103lan_ces
lancet84223573lan_cet
landed84619243lan_ded
lander74028483lan_der
landers84026213landers
landgrab1243033landgrab
landler84113203landler
landmen1038553landmen
lane45153333lan__e_
lanely93914483lan__ely
lanes54946793lan__es
lang56637383lang___
langleys1245103langleys
langrage10106033langrage
langrages11105903langrages
languets987243languets
languid936623languid
languor895423languor
langur7109303lang_ur
langurs889103langurs
lanital7310913lanital
lanker104123003lan_ker
lankier113711633lankier
lanner64920603lan_ner
lanneret82512363lanneret
lanners73618333lanners
lanose6313593lanose_
lantern7310013lantern
lapel73716683la__pel
laree56036293la__ree
lares54852633la__res
large65325463larg_e_
largely1136703larg_ely
larger74417513larg_er
larges74824233larg_es
lateral7313573lateral
laughed1235893laughed
laugher1136603laugher
laurels746663la_urels
layered11259413layered
lazaret16411783lazaret
linger75226003ling_er
lingered10129643lingered
lingerer9118303lingerer
lingers84223303lingers
lingier84113383lingier
lingoes84014693lingoes
lingual8379083lingual
lintel64013993lin_tel
longe66626463long_e_
longed87121373long_ed
longer75823203long_er
longers84819543longers
longes75925573long_es
longies82916553longies
lunge65323803lung_e_
lunged85418273lung_ed
lungee75119813lung_ee
lungees84412143lungees
lunger75720423lung_er
lungers83817093lungers
lunges76123423lung_es
lungful1144013lungful
maigre9309163maigre_
malgre9299303malgre_
mandrels1137313mandrels
mandril1049353mandril
mange84930193mang_e_
mangels103614493mang_els
manger94325003mang_er
mangers103521263mangers
manges94628943mang_es
mangey123614523mang_ey
mangier104114063mangier
mangle93921323mangle_
mangled113615263mangled
mangler103215643mangler
mangles104021463mangles
mangoes104316133mangoes
mangonel1185763mangonel
mantel84317973man_tel
manure8313653manure_
manured1039473manured
manurer938583manurer
manures9313353manures
maugre9308973maugre_
mongrels1135333mongrels
panel76023623pan__el
panged104722333pang_ed
pangen94115913pang_en
pangram1239023pangram
parrel84515983pa_rrel
range64728413rang_e_
ranged84824313rang_ed
ranger73925523rang_er
rangers83621043rangers
ranges73826923rang_es
rangier83714353rangier
sangaree949333sangaree
sanger74524563sang_er
sangers84421943sangers
sangria838113sangria
saurel6511993sa_urel
slanged94112853slang_ed
slangier9117933slangier
spandrel1144063spandrel
tanged84622493tang_ed
tangelo837033tang_elo
tangier83013903tangier
tangle74019953tangle_
tangled94214633tangled
tangler83515073tangler
tangles83920043tangles
tangoed9318833tangoed
tangram1038073tangram
tanrec837803tan_rec
wangle103817503wangle_
wangled123312413wangled
wangler113312653wangler
wangles113416933wangles
wastrel1037553wastrel

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 Limit1340272287.26618445.8
3Display Results2282280.0763000.0
 (SQL Overall)1786912287.49823831.8
 
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.