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
angel65019572_ang_el
gangrels1094972gangrels
langley1147452langley
langue71012182langue_
langues81211912langues
languet8713692languet
laurel649032la_urel
mandrel1038682mandrel
mangel94017542mang_el
mongrel1036332mongrel
agree65226033_a_gree
aigret73720023_aigret
angels74416173_ang_els
anger66225883_ang_er
angered93013473_angered
angerly1137773_angerly
angers75222543_angers
angle64528883_angle_
angled84219093_angled
angler74017863_angler
angles74426703_angles
angrier839023_angrier
angrily1137723_angrily
angry9310873_angr_y
antral65719413_antral
antre55224523_antre_
antres65021003_antres
anural65714743_anural
bagel85116793ba_g_el
banged104923733bang_ed
banger94423643bang_er
bangers104020353bangers
bangle94018963bangle_
bangles103617413bangles
barrel84517873ba_rrel
cancel105316683can_cel
cangue91012453cangue_
cangues10611823cangues
cannel84216403can_nel
carrel84718633ca_rrel
clanged114212653clang_ed
clanger104113493clang_er
clangers114312343clangers
clangored1343663clangored
danged94819493dang_ed
danger83722833dang_er
dangered11248513dangered
dangers94818213dangers
dangle84119313dangle_
dangled104013153dangled
dangler96912813dangler
dangles93618423dangles
doggrel1033883doggrel
eagre64315323ea_gre_
eagres74014573ea_gres
evangel1134303evang_el
fanged114318233fang_ed
flange103411973flang_e_
flanged123810843flang_ed
flanger113412623flang_er
flangers123311373flangers
flanges113413273flang_es
flannel1035423flan_nel
gambrel1235453gambrel
ganged94619203gang_ed
ganger83721473gang_er
gangers94418603gangers
gangrene1044363gangrene
gangue81310583gangue_
gangues9149753gangues
handsel11308723handsel
hangared1337573hangared
hanged114222403hang_ed
hanger104023263hang_er
hangers113120813hangers
hangmen1337383hangmen
hangul1049223hang_ul
hansel95214373han_sel
haverel13397153haverel
jangle144416303jangle_
jangled164111563jangled
jangler153811833jangler
jangles154015683jangles
laager74312783laag_er
laagered1055853laagered
laagers83411253laagers
label75019383la__bel
labored102810253labored
laborer9249513laborer
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
lang56637393lang___
langleys1245103langleys
langrage10106033langrage
langrages11105903langrages
languets987243languets
languid936623languid
languor895423languor
langur7109313lang_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
mange84930203mang_e_
mangels103614493mang_els
manger94325013mang_er
mangers103521263mangers
manges94628953mang_es
mangey123614533mang_ey
mangier104114063mangier
mangle93921333mangle_
mangled113615263mangled
mangler103215643mangler
mangles104021463mangles
mangoes104316133mangoes
mangonel1185763mangonel
mantel84317973man_tel
manure8313653manure_
manured1039473manured
manurer938583manurer
manures9313353manures
maugre9308973maugre_
mongrels1135333mongrels
panel76023623pan__el
panged104722343pang_ed
pangen94115923pang_en
pangram1239023pangram
parrel84515983pa_rrel
range64728423rang_e_
ranged84824323rang_ed
ranger73925533rang_er
rangers83621043rangers
ranges73826933rang_es
rangier83714353rangier
sangaree949333sangaree
sanger74524573sang_er
sangers84421943sangers
sangria838113sangria
saurel6511993sa_urel
slanged94112853slang_ed
slangier9117933slangier
spandrel1144063spandrel
tanged84622513tang_ed
tangelo837043tang_elo
tangier83013913tangier
tangle74019973tangle_
tangled94214643tangled
tangler83515083tangler
tangles83920053tangles
tangoed9318843tangoed
tangram1038083tangram
tanrec837813tan_rec
wangle103817513wangle_
wangled123312413wangled
wangler113312653wangler
wangles113416933wangles
wastrel1037553wastrel

Search took 7 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 Limit1340272286.01622278.4
3Display Results2282280.0763000.0
 (SQL Overall)1786912286.49827499.4
 
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.