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

202 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
grappler1333619(None) 
grapple12378001grapple_
grappled14336091grappled
grapplers14274301grapplers
grapples13348121grapples
crapper133913192crapp_er
crappier14288132crappier
crippler14826712crippler
gappier12369842g_appier
grabbler13377692grabbler
grapier103712602gra_pier
grasper10389782grasp_er
gripper124410712gripp_er
grippier1355202grippier
gripple12416612gripple_
rapper104621572_rapp_er
rippler113210102_rippler
trampler12278002trampler
trapper113912792trapp_er
wrapper14368332wrapp_er
ampler104313303__ampler
apple94517673__apple_
apples104315763__apples
applet105917433__applet
applier1137903__applier
brabbler11397373brabbler
brailler1036883brailler
brawler124310233bra_wler
capper124421983_capp_er
clapper134011863clapp_er
cradler102910503cra_dler
crampier14288903crampier
crapped143912623crapp_ed
crappers144011023crapp_ers
crappie13298983crappie_
crappies142911153crappies
crawler123510453cra_wler
cripple13378583cripple_
crippled15336793crippled
cripplers15314993cripplers
cripples14298403cripples
cropper133312963cropp_er
crupper13338563crupp_er
dapper114016633_dapp_er
dapple1138853_dapple_
dappled1336393_dappled
dapples1238993_dapples
draper94315693dra_p_er
drawler11338593dra_wler
dripper12349223dripp_er
drippier1385043drippier
dropper12329873dropp_er
flapper14359203flapp_er
flappier1544293flappier
frailer10319943fra_iler
frappe13286953frapp_e_
frapped15318853frapp_ed
frappes14328383frapp_es
gabbler124013303g_abbler
gambler123612683g_ambler
gaoler73913573g_a_oler
gaper86125123g_a_p_er
gapped124217123g_app_ed
garbler104012563g_arbler
gargler93710263g_argler
gasper94515543g_asp_er
gawper12499693g_awp_er
gipper114215303g_ipp_er
gloppier1354673gloppier
gospeler1173963gospeler
grabber12389763gra_bber
grabbier13316653grabbier
grabble12339643grabble_
grabbled14327373grabbled
grabblers14345513grabblers
grabbles13339893grabbles
gracile102512603gracile_
graciles112511613graciles
grackle14338893grackle_
grackles15309183grackles
grader84919693gra__der
grafter114211153gra_fter
grainer83714063gra_iner
grainier9218893grainier
grander93315873gra_nder
granger93514213gra_nger
granter84117133gra_nter
granular946893granular
granule839473granule_
granules939933granules
grape84824663gra_p_e_
grapery13457953gra_p_ery
grapes95123123gra_p_es
grapey126012303gra_p_ey
graphed1498473gra_phed
graplin1058443gra_plin
grapnel1035603gra_pnel
grapnels1134393grapnels
grappa11396443grapp__a
grappas12357103grapp_as
grappling1544993grappling
grasped11409063grasp_ed
graspers11338393grasp_ers
grassier9349283grassier
grater74625433gra__ter
graupel1034133graup_el
graupels1133103graupels
graveled13417363graveled
graver105018593gra__ver
grayer106014543gra__yer
grazer164815763gra__zer
grazier173611133gra_zier
griller84513353gr_iller
griper94114613gr_ip_er
gripier103210323gr_ipier
grippe115310323gripp_e_
gripped13419343gripp_ed
grippers13358123gripp_ers
grippes124810373gripp_es
grizzler17335033grizzler
groper94517253gr_op_er
grouper104210093group_er
groveler12305843groveler
growler11318973gr_owler
grueler837023gr_ueler
grueller935333grueller
grumbler13866683grumbler
grumpier1334803grumpier
gypper14347293g_ypp_er
happier143312033_happier
knapper15387153knapp_er
lapper104319953_lapp_er
mapper124516093_mapp_er
napper103718283_napp_er
nappier114411173_nappier
pappier103511593_pappier
prattler10166343prattler
preppier1156643preppier
rabbler113514093_rabbler
raffler13339223_raffler
railer64524933_ra_iler
rambler113313263_rambler
raper74932753_ra_p_er
rapider1067903_rapider
rapier84019993_ra_pier
rapped114122683_rapp_ed
rappee103618673_rapp_ee
rappees113611453_rappees
rappel104211953_rapp_el
rappeled1335003_rappeled
rappels11448803_rappels
rappen103512713_rapp_en
rappers113618443_rapp_ers
rasper83917323_rasp_er
raspier93110633_raspier
rattler74012743_rattler
raveler104212463_raveler
ripper103518653_ripp_er
ripple103413913_ripple_
rippled123110273_rippled
ripplers12337113_ripplers
ripples113513293_ripples
ripplet113412583_ripplet
ripplier1234463_ripplier
sampler113212013_sampler
sapper103822353_sapp_er
sappier113613113_sappier
scrapper1466953scrapp_er
scrappier1544413scrappier
scrapple1434683scrapple_
scrapples1534793scrapples
slapper113512463slapp_er
snapper113512073snapp_er
snappier1266213snappier
stapler93913623sta_pler
stippler1235543stippler
strapper1258083strapp_er
strappier1345123strappier
suppler1148433_suppler
swapper14359703swapp_er
tapper104419613_tapp_er
tippler11348343_tippler
trailer73015393tra_iler
tramper113812153tramp_er
trampier12318233trampier
trample11299703trample_
trampled13247903trampled
tramplers13305873tramplers
tramples122610203tramples
trapped124512213trapp_ed
trappers123711023trapp_ers
traveler11328433traveler
trawler104011903tra_wler
tripper113711923tripp_er
trippier1246623trippier
whapper17348273whapp_er
wrangler1245473wrangler
wrapped15338023wrapp_ed
wrappers15306933wrapp_ers
yapper133714513_yapp_er
zapper193414023_zapp_er
zappier20458373_zappier

Search took 10 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 Filter1786911461620.1701051123.5
2DLD Change Limit1461622028.84616522.9
3Display Results2022020.0762657.9
 (SQL Overall)1786912029.09219653.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.