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

229 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
grapnel103560(None) 
grapnels1134391grapnels
grained93814272grained
grainer83714062grainer
grape84824662grap_e_
grapes95123122grap_es
grapey126012302grap_ey
graphed1498472graphed
grapier103712602grapier
grapple12378002grapple
graupel1034132graupel
gravel105313822gra_vel
rappel104211952_rappel
shrapnel1342132shrapnel
apnea73413413__apnea
apneal83411123__apneal
appel94615893__appel
brained103816103brained
branned104311693branned
branner94212373branner
cannel84216403_cannel
carpel105418473carp_el
channel123910483channel
chapel134911373chap_el
charnel124010053charnel
cracknel1643703cracknel
crane75331603cra_ne_
craned96121653cra_ned
cranes84330753cra_nes
crape96128443crap_e_
craped116120523crap_ed
crapes104727693crap_es
crapped143912623crapped
crapper133913193crapper
crenel84213063cr_enel
darnel74312183_darnel
dragnet91211433dragnet
drained93713253drained
drainer83012843drainer
drape85319633drap_e_
draped105314363drap_ed
draper94315693drap_er
drapes95419653drap_es
drapey125010583drap_ey
empanel1145963empanel
flannel1035423flannel
frappe13286953frappe_
frapped15318853frapped
frappes14328383frappes
fresnel1035893fresnel
gained84617463g_ained
gainer74117493g_ainer
gane55145303g_a_ne_
ganef96322463g_a_nef
ganev95513863g_a_nev
gannet74321853g_annet
gape75134513g_ap_e_
gaped96123533g_ap_ed
gaper86125123g_ap_er
gapes86030823g_ap_es
gapped124217123g_apped
garner73917003g_arner
garnet73928413g_arnet
gavel95815183g_a_vel
gospel936533gosp_el
graal64316503gra__al
grabbed13368643grabbed
grabber12389763grabber
grabble12339643grabble
graben9419723gra_ben
grabens10367003grabens
grace85124543gra_ce_
graced105217903gra_ced
graces94523493gra_ces
gracile102512603gracile
grackle14338893grackle
grade75126093gra_de_
graded94919553gra_ded
grader84919693gra_der
grades84926313gra_des
gradine93317033gradine_
gradines103615253gradines
gradual936943gradual
grafted124110223grafted
grafter114211153grafter
grail64622873gra__il
grain65126253grain__
grainers93012073grainers
grainier9218903grainier
grains74223093grain_s
grainy103914213grain_y
gramme114210333gramme_
grammes123611323grammes
gran56335013gra_n__
grana65722093gra_n_a
grand75122693gra_n_d
grandee93115513grandee
grander93315873grander
grandly1238743gra_ndly
grands84218243gra_nds
grange83716203gra_nge
granger93514213granger
granges93516523granges
grannie8310353grannie
grannies9312613grannies
granny104311163gra_nny
granola837913gra_nola
grans64832543gra_n_s
grant64840023gra_n_t
granted94715103granted
grantee83217133grantee
granter84117133granter
grants73722473gra_nts
granule839473gra_nule
granum9310913gra_num
grapery13457953grapery
graph115315613grap__h
grapheme1644013grapheme
graphic1537353graphic
graphs124510153grap_hs
grapiest112211923grapiest
grapiness1238253grapiness
graplin1058443graplin
grapline1138723grapline_
graplines1237353graplines
grappa11396443grap_pa
grappas12357103grappas
grappled14336093grappled
grappler13336193grappler
grapples13348123grapples
grapy115416433grap__y
grasped11409063grasped
grasper10389793grasper
grassed93812793grassed
grasses84117343grasses
grate64932883gra_te_
grated84523923gra_ted
grater74625443gra_ter
grates75429893gra_tes
gratine84719193gratine_
gratinee93710783gratinee
graupels1133103graupels
grave94624873gra_ve_
graved114818813gra_ved
gravels113611143gra_vels
gravely14469063gra_vely
graven104513523gra_ven
graver105018593gra_ver
graves104624003gra_ves
gravies11314093gravies
grayed115415643gra_yed
grayer106014543gra_yer
grayness1235933grayness
graze155820053gra_ze_
grazed174115913gra_zed
grazer164815763gra_zer
grazes164519643gra_zes
grazier173611133grazier
greened93111263greened
greener83111713greener
grinned9378553grinned
grinner8329233grinner
gripe84622963grip_e_
griped104114713grip_ed
griper94114613grip_er
gripes94619873grip_es
gripey124111203grip_ey
gripier103210323gripier
gripmen1235033gripmen
grippe115310323grippe_
gripped13419343gripped
gripper124410713gripper
grippes124810373grippes
gripple12416613gripple
groaned9259973groaned
groaner82510133groaner
groined92710813groined
grope84821613grop_e_
groped107515053grop_ed
groper94517253grop_er
gropes95220403grop_es
grovel104310543gr_ovel
groyne1037213groyne_
groynes1137823groynes
gruel66014743gr__uel
gunnel73411053g_unnel
impanel1137093impanel
lapel73716683_lap_el
panel76023623_pa_nel
prawned1346743prawned
prawner1246803prawner
propel103714063prop_el
rained75024603_rained
ranee55438103_ra_nee
rape65041633_rap_e_
raped85334623_rap_ed
raper74932753_rap_er
rapes75740723_rap_es
raphe104916423_raphe_
raphes115117453_raphes
rapier84019993_rapier
rapine85023083_rapine_
rapines95120863_rapines
rapped114122683_rapped
rappee103618673_rappee
rappels11448803_rappels
rappen103512713_rappen
rapper104621573_rapper
ratel54224883_ra_tel
ravel84621513_ra_vel
repanel939963_repanel
repel74921403_rep_el
ronnel63310883_ronnel
runnel63510663_runnel
scrannel1044033scrannel
trained84117203trained
trainee72817793trainee
trainer73316793trainer
tramel84113713tra_mel
trammel11357663trammel
trapes85024463trap_es
trapnest10310923trapnest
trapped124512213trapped
trapper113912803trapper
travel94112983tra_vel
trunnel745403trunnel
uranyl936293ura_nyl
wrapped15338023wrapped
wrapper14368333wrapper

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.423422437.4
2DLD Change Limit1340272296.62320236.6
3Display Results2292290.0802862.5
 (SQL Overall)1786912297.12625075.9
 
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.