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

335 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
needler838889(None) 
needer73614951need_er
needier84010621needier
needle73310611needle_
needled9358511needled
needlers9287421needlers
needles83211561needles
beetler938032beetler
deedier93011592deedier
feebler1235822feebler
feeder103513842feed_er
feeler93215172fee_ler
heeder104216042heed_er
heeler93917312hee_ler
kneeler11277572knee_ler
meddler11319952meddler
needed84114442need_ed
needers84111902need_ers
needless9308332needless
nerdier83110352nerdier
nestler73510442nestler
nettler7349502nettler
peddler113210492peddler
pedler93614622_pedler
peeler83517382pee_ler
reedier83815302reedier
reeler63822572ree_ler
seeder74320772seed_er
seedier83513632seedier
weeder103315512weed_er
weedier113810622weedier
wheedler1543542wheedler
annealer845503annealer
beader94623793bead_er
beadier103513913beadier
beadle93314683beadle_
beadles103414733beadles
bedder104215793_bedder
beedies10314203beedies
beefier12329093beefier
beeper103714093bee_per
beerier93613023beerier
beetle8311673beetle_
beetled1038213beetled
beetlers1037393beetlers
beetles9312083beetles
beezer174010523bee_zer
bender95223303bend_er
bendier103111413bendier
beveler124010683beveler
beveller13387663beveller
bleeder10359643bleed_er
boodler103312003boodler
breeder103210043breed_er
bridler103811073bridler
bundler104011723bundler
candler103516593candler
ceder85322243_ced_er
ceiler84013963_ceiler
cheder125113493ched_er
coddler113710833coddler
cradler102910513cradler
cuddler113810743cuddler
curdler103511563curdler
dandler94414273dandler
dawdler12356793dawdler
deader84220473dead_er
deadlier1036863deadlier
dealer74122143_dealer
deeded94615543deed_ed
deedless10318253deedless
deeper93613503dee_per
defiler113911883defiler
diddler103511513diddler
doodler93310153doodler
dredger10347453dredger
dueler74213683due_ler
dueller8329833dueller
dweller11297273dweller
edger75215953__edger
eelier64216463_eelier
eerier64320023_eerier
eider64624743_eid_er
elder64020023_eld_er
enabler9299363enabler
ender64325863_end_er
enfeebler14172133enfeebler
eviler94811893_eviler
exiler134712183_exiler
feeble1138253feeble_
feeders113712863feed_ers
feedlot11135933feedlot
feelers103814743fee_lers
feller94419553_feller
fender103718723fend_er
fiddler12309953fiddler
fielder11217413fielder
fondler11348883fondler
fueler94313933fue_ler
fueller10279963fueller
geekier12286393geekier
geezer16278013gee_zer
gelder84613713geld_er
gender83517933gend_er
gentler8378953gentler
girdler9227313girdler
greedier1036083greedier
handler113516163handler
header104422543head_er
headier113212953headier
healer94221803_healer
heckler16278573heckler
heddle114211163heddle_
heddles123311623heddles
heder95623643_hed_er
hedger114912653_hedger
heeded114215763heed_ed
heeders114213743heed_ers
heedless12278813heedless
heeled104018413hee_led
heelers103815623hee_lers
heller93322513_heller
herder104516463herd_er
huddler12379423huddler
hurdler113610003hurdler
idler65015663__idler
jeerer13389933jee_rer
jeweler1735053jeweler
jeweller1844123jeweller
keeled114414273kee_led
keener104012843kee_ner
keeper123811923kee_per
keester11319913keester
kegeler1245493kegeler
kegler11398243_kegler
kindler12309983kindler
kneader1275893knead_er
kneeled12328073knee_led
kneelers12226213knee_lers
ladler74314933_ladler
landler84113203landler
leader74824653lead_er
leadier83212723leadier
ledger85914393_ledger
leerier73111503leerier
lender73921273lend_er
leveler10399903leveler
leveller11317593leveller
lewder10479613lewd_er
lieder74912323lied_er
meddle103312763meddle_
meddled123210033meddled
meddlers12318203meddlers
meddles113213253meddles
medlar93010463_medlar
medley1298343_medley
meeker12359983mee_ker
meeter83616503mee_ter
melder93915813meld_er
mender93520793mend_er
mewler113510233_mewler
middler112712273middler
modeler1039293modeler
muddler113411623muddler
nailer64119363n_ailer
nakeder1254363naked_er
nearer64618893n_earer
nearlier836793nearlier
neater64424313n_eater
nebular956483nebular
nebule848753nebule_
necker124012793n_ecker
neddies92710703neddies
need54934153need___
needful1143863needful
neediest92611303neediest
needily1166323needily
needing93214423needing
needlework1851463needlework
needling10248753needling
needs65719633need__s
needy94614693need__y
negater83711963negater
neither1037573neither
nervier10298833nervier
nester64124183n_ester
nestle63013953nestle_
nestled8349903nestled
nestlers8359223nestlers
nestles73015463nestles
nether94014163n_ether
netter63722023n_etter
nettier74211813nettier
nettle64514583nettle_
nettled8339943nettled
nettlers8307513nettlers
nettles73214083nettles
nettlier864813nettlier
neuter63713793n_euter
never86218643n_e_ver
newer85717463n_e_wer
newsier10147223newsier
nibbler11379273nibbler
niggler93610293niggler
nimbler11358063nimbler
nobbler113211183nobbler
nobler83713453n_obler
nodder84811943n_odder
noddle83211363noddle_
noddled10358563noddled
noddles92911293noddles
noodle73212543noodle_
noodled9339923noodled
noodles83513193noodles
nuder66416833n_ud_er
nudger85111643n_udger
nuzzler15296493nuzzler
paddler113711553paddler
pearler9310373pearler
pedaler103410693pedaler
peddle103512823peddle_
peddled123410543peddled
peddlers12298533peddlers
peddlery15224013peddlery
peddles112913703peddles
pedlar93311273_pedlar
pedlers103013273_pedlers
pedlery13297083_pedlery
peeled94119713pee_led
peelers93615593pee_lers
peeper103614803pee_per
peopler1138083peopler
piddler112911523piddler
pledger11359173pledger
puddler112910753puddler
queller16289293queller
reader73628293read_er
readier83117423readier
realer63528593_realer
redder83918143_redder
reddle83815913reddle_
reddled102912323reddled
reddles93315773reddles
redleg839273_redleg
reeded84022563reed_ed
reedmen1038333reedmen
reefer93314363ree_fer
reefier102912553reefier
reeker103715593ree_ker
reekier113111123reekier
reeled74725533ree_led
reelers73520273ree_lers
reenter73217793reenter
regaler83814623regaler
render74024143rend_er
repealer103210703repealer
repeller103010393repeller
reseller83412223reseller
revealer113110073revealer
reveler104116343reveler
reveller112912183reveller
reviler104314973reviler
riddler93411263riddler
saddler93811963saddler
sealer63928963_sealer
seceder10329573seced_er
seder64826763_sed_er
seedbed11246613seedbed
seeded84520463seed_ed
seeders83017113seed_ers
seedless9319513seedless
seedmen1037683seedmen
seeker103615363see_ker
seeled73922093see_led
seemer84418043see_mer
seemlier1035193seemlier
seepier92912013seepier
seller63824593_seller
sender73824413send_er
settler73410653settler
shedder12339323shedder
sheller103515883sheller
sidler74716963_sidler
sledder9399203sledder
smeller94212783smeller
sneerer73512313snee_rer
sneerier878103sneerier
sneezer16237963snee_zer
sneezier1774333sneezier
sneller73512843sneller
speeder103811073speed_er
speedier1146623speedier
speller95415143speller
stealer72913973stealer
sweller103012463sweller
tedder83312163_tedder
teemer85515743tee_mer
teener64717503tee_ner
teenier72611143teenier
teeter65420313tee_ter
teether10349693teether
teller63519813_teller
tender74121843tend_er
tiddler93110003tiddler
toddler9379043toddler
treadler936863treadler
tweedier1253623tweedier
tweedle1134193tweedle_
tweedled1332833tweedled
tweedles1234113tweedles
unreeler8127293unreeler
vealer94016543_vealer
veiler93814353_veiler
vender103418423vend_er
waddler124010793waddler
wedder113612303_wedder
wedeled1237783wedeled
weeded113914873weed_ed
weeders113412933weed_ers
weedless12287963weedless
weenier103210803weenier
weeper114313303wee_per
weepier12319273weepier
weever123811443wee_ver
welder102914413weld_er
wheedle1434823wheedle_
wheedled1633033wheedled
wheedlers1643193wheedlers
wheedles1534643wheedles
wheeler13298773wheeler
wielder11197673wielder
yeller94214513_yeller
yielder11175113yielder
yodeler1136343yodeler
yodler10389943_yodler

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.403443402.0
2DLD Change Limit1340273356.83019623.3
3Display Results3353350.1103045.5
 (SQL Overall)1786913357.34324334.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.